Supply Chain Analysis

Dataset statistics

Number of variables	53
Number of observations	180519
Missing cells	336209
Missing cells (%)	3.5%
Duplicate rows	0
Duplicate rows (%)	0.0%
Total size in memory	73.0 MiB
Average record size in memory	424.0 B

Variable types

Categorical	28
Numeric	24
Unsupported	1

Alerts

`customer_email` has constant value ""	Constant
`customer_password` has constant value ""	Constant
`product_status` has constant value ""	Constant
`customer_city` has a high cardinality: 563 distinct values	High cardinality
`customer_fname` has a high cardinality: 782 distinct values	High cardinality
`customer_lname` has a high cardinality: 1109 distinct values	High cardinality
`customer_street` has a high cardinality: 7458 distinct values	High cardinality
`order_city` has a high cardinality: 3597 distinct values	High cardinality
`order_country` has a high cardinality: 164 distinct values	High cardinality
`order_date_dateorders` has a high cardinality: 65752 distinct values	High cardinality
`order_state` has a high cardinality: 1089 distinct values	High cardinality
`product_image` has a high cardinality: 118 distinct values	High cardinality
`product_name` has a high cardinality: 118 distinct values	High cardinality
`shipping_date_dateorders` has a high cardinality: 63701 distinct values	High cardinality
`days_for_shipping_real` is highly overall correlated with `days_for_shipment_scheduled` and 3 other fields	High correlation
`benefit_per_order` is highly overall correlated with `order_item_profit_ratio` and 1 other fields	High correlation
`sales_per_customer` is highly overall correlated with `order_item_product_price` and 3 other fields	High correlation
`category_id` is highly overall correlated with `department_id` and 5 other fields	High correlation
`customer_id` is highly overall correlated with `order_customer_id` and 1 other fields	High correlation
`customer_zipcode` is highly overall correlated with `latitude` and 3 other fields	High correlation
`department_id` is highly overall correlated with `category_id` and 5 other fields	High correlation
`latitude` is highly overall correlated with `customer_zipcode` and 3 other fields	High correlation
`longitude` is highly overall correlated with `customer_zipcode` and 3 other fields	High correlation
`order_customer_id` is highly overall correlated with `customer_id` and 1 other fields	High correlation
`order_id` is highly overall correlated with `order_item_id` and 2 other fields	High correlation
`order_item_cardprod_id` is highly overall correlated with `category_id` and 5 other fields	High correlation
`order_item_discount` is highly overall correlated with `order_item_discount_rate` and 1 other fields	High correlation
`order_item_discount_rate` is highly overall correlated with `order_item_discount`	High correlation
`order_item_id` is highly overall correlated with `order_id` and 2 other fields	High correlation
`order_item_product_price` is highly overall correlated with `sales_per_customer` and 4 other fields	High correlation
`order_item_profit_ratio` is highly overall correlated with `benefit_per_order` and 1 other fields	High correlation
`sales` is highly overall correlated with `sales_per_customer` and 5 other fields	High correlation
`order_item_total` is highly overall correlated with `sales_per_customer` and 3 other fields	High correlation
`order_profit_per_order` is highly overall correlated with `benefit_per_order` and 1 other fields	High correlation
`order_zipcode` is highly overall correlated with `market` and 1 other fields	High correlation
`product_card_id` is highly overall correlated with `category_id` and 5 other fields	High correlation
`product_category_id` is highly overall correlated with `category_id` and 5 other fields	High correlation
`product_price` is highly overall correlated with `sales_per_customer` and 4 other fields	High correlation
`type` is highly overall correlated with `order_status`	High correlation
`days_for_shipment_scheduled` is highly overall correlated with `days_for_shipping_real` and 1 other fields	High correlation
`delivery_status` is highly overall correlated with `days_for_shipping_real` and 2 other fields	High correlation
`late_delivery_risk` is highly overall correlated with `days_for_shipping_real` and 1 other fields	High correlation
`category_name` is highly overall correlated with `category_id` and 10 other fields	High correlation
`customer_country` is highly overall correlated with `customer_zipcode` and 3 other fields	High correlation
`customer_state` is highly overall correlated with `customer_zipcode` and 3 other fields	High correlation
`department_name` is highly overall correlated with `category_id` and 5 other fields	High correlation
`market` is highly overall correlated with `order_id` and 3 other fields	High correlation
`order_region` is highly overall correlated with `order_id` and 3 other fields	High correlation
`order_status` is highly overall correlated with `type` and 1 other fields	High correlation
`shipping_mode` is highly overall correlated with `days_for_shipping_real` and 1 other fields	High correlation
`order_zipcode` has 155679 (86.2%) missing values	Missing
`product_description` has 180519 (100.0%) missing values	Missing
`order_date_dateorders` is uniformly distributed	Uniform
`order_item_id` is uniformly distributed	Uniform
`shipping_date_dateorders` is uniformly distributed	Uniform
`order_item_id` has unique values	Unique
`product_description` is an unsupported type, check if it needs cleaning or further analysis	Unsupported
`days_for_shipping_real` has 5080 (2.8%) zeros	Zeros
`order_item_discount` has 10028 (5.6%) zeros	Zeros
`order_item_discount_rate` has 10028 (5.6%) zeros	Zeros

Reproduction

Analysis started	2023-06-29 02:00:01.861334
Analysis finished	2023-06-29 02:01:01.545218
Duration	59.68 seconds
Software version	ydata-profiling vv4.0.0
Download configuration	config.json

type
Categorical

Distinct	4
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	1.4 MiB

DEBIT	69295
TRANSFER	49883
PAYMENT	41725
CASH	19616

Length

Max length	8
Median length	7
Mean length	6.1826068
Min length	4

Characters and Unicode

Total characters	1116078
Distinct characters	15
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	DEBIT
2nd row	TRANSFER
3rd row	CASH
4th row	DEBIT
5th row	PAYMENT

Common Values

Value	Count	Frequency (%)
DEBIT	69295	38.4%
TRANSFER	49883	27.6%
PAYMENT	41725	23.1%
CASH	19616	10.9%

Length

Histogram of lengths of the category

Common Values (Plot)

Value	Count	Frequency (%)
debit	69295	38.4%
transfer	49883	27.6%
payment	41725	23.1%
cash	19616	10.9%

Most occurring characters

Value	Count	Frequency (%)
E	160903	14.4%
T	160903	14.4%
A	111224	10.0%
R	99766	8.9%
N	91608	8.2%
S	69499	6.2%
D	69295	6.2%
B	69295	6.2%
I	69295	6.2%
F	49883	4.5%
Other values (5)	164407	14.7%

Most occurring categories

Value	Count	Frequency (%)
Uppercase Letter	1116078	100.0%

Most frequent character per category

Uppercase Letter

Value	Count	Frequency (%)
E	160903	14.4%
T	160903	14.4%
A	111224	10.0%
R	99766	8.9%
N	91608	8.2%
S	69499	6.2%
D	69295	6.2%
B	69295	6.2%
I	69295	6.2%
F	49883	4.5%
Other values (5)	164407	14.7%

Most occurring scripts

Value	Count	Frequency (%)
Latin	1116078	100.0%

Most frequent character per script

Latin

Value	Count	Frequency (%)
E	160903	14.4%
T	160903	14.4%
A	111224	10.0%
R	99766	8.9%
N	91608	8.2%
S	69499	6.2%
D	69295	6.2%
B	69295	6.2%
I	69295	6.2%
F	49883	4.5%
Other values (5)	164407	14.7%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	1116078	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
E	160903	14.4%
T	160903	14.4%
A	111224	10.0%
R	99766	8.9%
N	91608	8.2%
S	69499	6.2%
D	69295	6.2%
B	69295	6.2%
I	69295	6.2%
F	49883	4.5%
Other values (5)	164407	14.7%

days_for_shipping_real
Real number (ℝ)

HIGH CORRELATION ZEROS

Distinct	7
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	3.497654

Minimum	0
Maximum	6
Zeros	5080
Zeros (%)	2.8%
Negative	0
Negative (%)	0.0%
Memory size	1.4 MiB

Quantile statistics

Minimum	0
5-th percentile	1
Q1	2
median	3
Q3	5
95-th percentile	6
Maximum	6
Range	6
Interquartile range (IQR)	3

Descriptive statistics

Standard deviation	1.6237218
Coefficient of variation (CV)	0.46423169
Kurtosis	-1.0079136
Mean	3.497654
Median Absolute Deviation (MAD)	1
Skewness	0.084771273
Sum	631393
Variance	2.6364726
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=7)

Value	Count	Frequency (%)
2	56618	31.4%
3	28765	15.9%
6	28723	15.9%
4	28513	15.8%
5	28163	15.6%
0	5080	2.8%
1	4657	2.6%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
0	5080	2.8%
1	4657	2.6%
2	56618	31.4%
3	28765	15.9%
4	28513	15.8%
5	28163	15.6%
6	28723	15.9%

Value	Count	Frequency (%)
6	28723	15.9%
5	28163	15.6%
4	28513	15.8%
3	28765	15.9%
2	56618	31.4%
1	4657	2.6%
0	5080	2.8%

days_for_shipment_scheduled
Categorical

Distinct	4
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	1.4 MiB

4	107752
2	35216
1	27814
0	9737

Length

Max length	1
Median length	1
Mean length	1
Min length	1

Characters and Unicode

Total characters	180519
Distinct characters	4
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	4
2nd row	4
3rd row	4
4th row	4
5th row	4

Common Values

Value	Count	Frequency (%)
4	107752	59.7%
2	35216	19.5%
1	27814	15.4%
0	9737	5.4%

Length

Histogram of lengths of the category

Common Values (Plot)

Value	Count	Frequency (%)
4	107752	59.7%
2	35216	19.5%
1	27814	15.4%
0	9737	5.4%

Most occurring characters

Value	Count	Frequency (%)
4	107752	59.7%
2	35216	19.5%
1	27814	15.4%
0	9737	5.4%

Most occurring categories

Value	Count	Frequency (%)
Decimal Number	180519	100.0%

Most frequent character per category

Decimal Number

Value	Count	Frequency (%)
4	107752	59.7%
2	35216	19.5%
1	27814	15.4%
0	9737	5.4%

Most occurring scripts

Value	Count	Frequency (%)
Common	180519	100.0%

Most frequent character per script

Common

Value	Count	Frequency (%)
4	107752	59.7%
2	35216	19.5%
1	27814	15.4%
0	9737	5.4%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	180519	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
4	107752	59.7%
2	35216	19.5%
1	27814	15.4%
0	9737	5.4%

benefit_per_order
Real number (ℝ)

Distinct	21998
Distinct (%)	12.2%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	21.974989

Minimum	-4274.98
Maximum	911.79999
Zeros	1177
Zeros (%)	0.7%
Negative	33784
Negative (%)	18.7%
Memory size	1.4 MiB

Quantile statistics

Minimum	-4274.98
5-th percentile	-139.251
Q1	7
median	31.52
Q3	64.800003
95-th percentile	132.28999
Maximum	911.79999
Range	5186.78
Interquartile range (IQR)	57.800003

Descriptive statistics

Standard deviation	104.43353
Coefficient of variation (CV)	4.7523813
Kurtosis	71.377259
Mean	21.974989
Median Absolute Deviation (MAD)	27.88
Skewness	-4.7418341
Sum	3966903
Variance	10906.361
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
0	1177	0.7%
143.9900055	199	0.1%
72	194	0.1%
46.79999924	188	0.1%
24	181	0.1%
18	175	0.1%
63.70000076	172	0.1%
62.40000153	168	0.1%
12	166	0.1%
14.39999962	166	0.1%
Other values (21988)	177733	98.5%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
-4274.97998	1	< 0.1%
-3442.5	1	< 0.1%
-3366	1	< 0.1%
-3000	1	< 0.1%
-2592	1	< 0.1%
-2550	1	< 0.1%
-2351.25	1	< 0.1%
-2328	1	< 0.1%
-2280	1	< 0.1%
-2255.25	1	< 0.1%

Value	Count	Frequency (%)
911.7999878	1	< 0.1%
864	1	< 0.1%
721.5999756	1	< 0.1%
720.2999878	1	< 0.1%
720	2	< 0.1%
712.9500122	1	< 0.1%
708.75	1	< 0.1%
705.5999756	2	< 0.1%
705	1	< 0.1%
698.4000244	2	< 0.1%

sales_per_customer
Real number (ℝ)

Distinct	2927
Distinct (%)	1.6%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	183.10761

Minimum	7.4899998
Maximum	1939.99
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	1.4 MiB

Quantile statistics

Minimum	7.4899998
5-th percentile	41.5
Q1	104.38
median	163.99001
Q3	247.39999
95-th percentile	383.98001
Maximum	1939.99
Range	1932.5
Interquartile range (IQR)	143.02

Descriptive statistics

Standard deviation	120.04367
Coefficient of variation (CV)	0.65559084
Kurtosis	23.920362
Mean	183.10761
Median Absolute Deviation (MAD)	67.000008
Skewness	2.8884461
Sum	33054402
Variance	14410.483
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
122.8399963	1264	0.7%
109.1900024	1247	0.7%
124.7900009	1243	0.7%
129.9900055	1243	0.7%
116.9899979	1243	0.7%
123.4899979	1243	0.7%
120.8899994	1243	0.7%
127.3899994	1243	0.7%
97.48999786	1243	0.7%
118.2900009	1243	0.7%
Other values (2917)	168064	93.1%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
7.489999771	3	< 0.1%
7.989999771	3	< 0.1%
8.18999958	3	< 0.1%
8.289999962	3	< 0.1%
8.390000343	3	< 0.1%
8.470000267	15	< 0.1%
8.489999771	3	< 0.1%
8.659999847	29	< 0.1%
8.68999958	3	< 0.1%
8.789999962	3	< 0.1%

Value	Count	Frequency (%)
1939.98999	1	< 0.1%
1919.98999	1	< 0.1%
1899.98999	1	< 0.1%
1889.98999	1	< 0.1%
1859.98999	1	< 0.1%
1819.98999	1	< 0.1%
1799.98999	1	< 0.1%
1759.98999	1	< 0.1%
1739.98999	1	< 0.1%
1699.98999	1	< 0.1%

delivery_status
Categorical

Distinct	4
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	1.4 MiB

Late delivery	98977
Advance shipping	41592
Shipping on time	32196
Shipping canceled	7754

Length

Max length	17
Median length	13
Mean length	14.39808
Min length	13

Characters and Unicode

Total characters	2599127
Distinct characters	21
Distinct categories	3 ?
Distinct scripts	2 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	Advance shipping
2nd row	Late delivery
3rd row	Shipping on time
4th row	Advance shipping
5th row	Advance shipping

Common Values

Value	Count	Frequency (%)
Late delivery	98977	54.8%
Advance shipping	41592	23.0%
Shipping on time	32196	17.8%
Shipping canceled	7754	4.3%

Length

Histogram of lengths of the category

Common Values (Plot)

Value	Count	Frequency (%)
late	98977	25.2%
delivery	98977	25.2%
shipping	81542	20.7%
advance	41592	10.6%
on	32196	8.2%
time	32196	8.2%
canceled	7754	2.0%

Most occurring characters

Value	Count	Frequency (%)
e	386227	14.9%
i	294257	11.3%
	212715	8.2%
n	163084	6.3%
p	163084	6.3%
d	148323	5.7%
a	148323	5.7%
v	140569	5.4%
t	131173	5.0%
l	106731	4.1%
Other values (11)	704641	27.1%

Most occurring categories

Value	Count	Frequency (%)
Lowercase Letter	2205893	84.9%
Space Separator	212715	8.2%
Uppercase Letter	180519	6.9%

Most frequent character per category

Lowercase Letter

Value	Count	Frequency (%)
e	386227	17.5%
i	294257	13.3%
n	163084	7.4%
p	163084	7.4%
d	148323	6.7%
a	148323	6.7%
v	140569	6.4%
t	131173	5.9%
l	106731	4.8%
y	98977	4.5%
Other values (7)	425145	19.3%

Uppercase Letter

Value	Count	Frequency (%)
L	98977	54.8%
A	41592	23.0%
S	39950	22.1%

Space Separator

Value	Count	Frequency (%)
	212715	100.0%

Most occurring scripts

Value	Count	Frequency (%)
Latin	2386412	91.8%
Common	212715	8.2%

Most frequent character per script

Latin

Value	Count	Frequency (%)
e	386227	16.2%
i	294257	12.3%
n	163084	6.8%
p	163084	6.8%
d	148323	6.2%
a	148323	6.2%
v	140569	5.9%
t	131173	5.5%
l	106731	4.5%
L	98977	4.1%
Other values (10)	605664	25.4%

Common

Value	Count	Frequency (%)
	212715	100.0%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	2599127	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
e	386227	14.9%
i	294257	11.3%
	212715	8.2%
n	163084	6.3%
p	163084	6.3%
d	148323	5.7%
a	148323	5.7%
v	140569	5.4%
t	131173	5.0%
l	106731	4.1%
Other values (11)	704641	27.1%

late_delivery_risk
Categorical

Distinct	2
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	1.4 MiB

1	98977
0	81542

Length

Max length	1
Median length	1
Mean length	1
Min length	1

Characters and Unicode

Total characters	180519
Distinct characters	2
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	0
2nd row	1
3rd row	0
4th row	0
5th row	0

Common Values

Value	Count	Frequency (%)
1	98977	54.8%
0	81542	45.2%

Length

Histogram of lengths of the category

Common Values (Plot)

Value	Count	Frequency (%)
1	98977	54.8%
0	81542	45.2%

Most occurring characters

Value	Count	Frequency (%)
1	98977	54.8%
0	81542	45.2%

Most occurring categories

Value	Count	Frequency (%)
Decimal Number	180519	100.0%

Most frequent character per category

Decimal Number

Value	Count	Frequency (%)
1	98977	54.8%
0	81542	45.2%

Most occurring scripts

Value	Count	Frequency (%)
Common	180519	100.0%

Most frequent character per script

Common

Value	Count	Frequency (%)
1	98977	54.8%
0	81542	45.2%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	180519	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
1	98977	54.8%
0	81542	45.2%

category_id
Real number (ℝ)

Distinct	51
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	31.851451

Minimum	2
Maximum	76
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	1.4 MiB

Quantile statistics

Minimum	2
5-th percentile	9
Q1	18
median	29
Q3	45
95-th percentile	48
Maximum	76
Range	74
Interquartile range (IQR)	27

Descriptive statistics

Standard deviation	15.640064
Coefficient of variation (CV)	0.49103145
Kurtosis	-0.60326101
Mean	31.851451
Median Absolute Deviation (MAD)	14
Skewness	0.3616248
Sum	5749792
Variance	244.6116
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
17	24551	13.6%
18	22246	12.3%
24	21035	11.7%
46	19298	10.7%
45	17325	9.6%
48	15540	8.6%
43	13729	7.6%
9	12487	6.9%
29	10984	6.1%
37	2029	1.1%
Other values (41)	21295	11.8%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
2	138	0.1%
3	632	0.4%
4	67	< 0.1%
5	343	0.2%
6	328	0.2%
7	614	0.3%
9	12487	6.9%
10	111	0.1%
11	309	0.2%
12	423	0.2%

Value	Count	Frequency (%)
76	650	0.4%
75	838	0.5%
74	529	0.3%
73	357	0.2%
72	492	0.3%
71	434	0.2%
70	208	0.1%
69	362	0.2%
68	484	0.3%
67	483	0.3%

category_name
Categorical

Distinct	50
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	1.4 MiB

Cleats	24551
Men's Footwear	22246
Women's Apparel	21035
Indoor/Outdoor Games	19298
Fishing	17325
Other values (45)	76064

Length

Max length	20
Median length	17
Mean length	12.707793
Min length	4

Characters and Unicode

Total characters	2293998
Distinct characters	49
Distinct categories	5 ?
Distinct scripts	2 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	Sporting Goods
2nd row	Sporting Goods
3rd row	Sporting Goods
4th row	Sporting Goods
5th row	Sporting Goods

Common Values

Value	Count	Frequency (%)
Cleats	24551	13.6%
Men's Footwear	22246	12.3%
Women's Apparel	21035	11.7%
Indoor/Outdoor Games	19298	10.7%
Fishing	17325	9.6%
Water Sports	15540	8.6%
Camping & Hiking	13729	7.6%
Cardio Equipment	12487	6.9%
Shop By Sport	10984	6.1%
Electronics	3156	1.7%
Other values (40)	20168	11.2%

Length

Histogram of lengths of the category

Value	Count	Frequency (%)
cleats	24551	7.3%
men's	22737	6.8%
apparel	22677	6.8%
footwear	22246	6.6%
women's	21866	6.5%
games	20136	6.0%
indoor/outdoor	19298	5.7%
fishing	17325	5.2%
	15613	4.7%
water	15540	4.6%
Other values (60)	133774	39.8%

Most occurring characters

Value	Count	Frequency (%)
o	213963	9.3%
e	180726	7.9%
	156787	6.8%
r	150127	6.5%
s	145604	6.3%
a	140194	6.1%
n	132705	5.8%
t	130741	5.7%
i	114517	5.0%
p	110861	4.8%
Other values (39)	817773	35.6%

Most occurring categories

Value	Count	Frequency (%)
Lowercase Letter	1712275	74.6%
Uppercase Letter	342143	14.9%
Space Separator	156787	6.8%
Other Punctuation	81819	3.6%
Dash Punctuation	974	< 0.1%

Most frequent character per category

Lowercase Letter

Value	Count	Frequency (%)
o	213963	12.5%
e	180726	10.6%
r	150127	8.8%
s	145604	8.5%
a	140194	8.2%
n	132705	7.8%
t	130741	7.6%
i	114517	6.7%
p	110861	6.5%
m	69683	4.1%
Other values (14)	323154	18.9%

Uppercase Letter

Value	Count	Frequency (%)
C	56058	16.4%
S	40270	11.8%
F	39880	11.7%
W	37406	10.9%
G	27667	8.1%
A	25257	7.4%
M	24017	7.0%
I	20272	5.9%
O	19298	5.6%
E	16074	4.7%
Other values (9)	35944	10.5%

Other Punctuation

Value	Count	Frequency (%)
'	46840	57.2%
/	19298	23.6%
&	15613	19.1%
!	68	0.1%

Space Separator

Value	Count	Frequency (%)
	156787	100.0%

Dash Punctuation

Value	Count	Frequency (%)
-	974	100.0%

Most occurring scripts

Value	Count	Frequency (%)
Latin	2054418	89.6%
Common	239580	10.4%

Most frequent character per script

Latin

Value	Count	Frequency (%)
o	213963	10.4%
e	180726	8.8%
r	150127	7.3%
s	145604	7.1%
a	140194	6.8%
n	132705	6.5%
t	130741	6.4%
i	114517	5.6%
p	110861	5.4%
m	69683	3.4%
Other values (33)	665297	32.4%

Common

Value	Count	Frequency (%)
	156787	65.4%
'	46840	19.6%
/	19298	8.1%
&	15613	6.5%
-	974	0.4%
!	68	< 0.1%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	2293998	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
o	213963	9.3%
e	180726	7.9%
	156787	6.8%
r	150127	6.5%
s	145604	6.3%
a	140194	6.1%
n	132705	5.8%
t	130741	5.7%
i	114517	5.0%
p	110861	4.8%
Other values (39)	817773	35.6%

customer_city
Categorical

Distinct	563
Distinct (%)	0.3%
Missing	0
Missing (%)	0.0%
Memory size	1.4 MiB

Caguas	66770
Chicago	3885
Los Angeles	3417
Brooklyn	3412
New York	1816
Other values (558)	101219

Length

Max length	20
Median length	19
Mean length	7.7086235
Min length	2

Characters and Unicode

Total characters	1391553
Distinct characters	52
Distinct categories	3 ?
Distinct scripts	2 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	Caguas
2nd row	Caguas
3rd row	San Jose
4th row	Los Angeles
5th row	Caguas

Common Values

Value	Count	Frequency (%)
Caguas	66770	37.0%
Chicago	3885	2.2%
Los Angeles	3417	1.9%
Brooklyn	3412	1.9%
New York	1816	1.0%
Philadelphia	1577	0.9%
Bronx	1500	0.8%
San Diego	1437	0.8%
Miami	1314	0.7%
Houston	1297	0.7%
Other values (553)	94094	52.1%

Length

Histogram of lengths of the category

Value	Count	Frequency (%)
caguas	66770	30.8%
san	5129	2.4%
chicago	3937	1.8%
los	3417	1.6%
angeles	3417	1.6%
brooklyn	3412	1.6%
new	3107	1.4%
york	2165	1.0%
beach	2084	1.0%
city	1659	0.8%
Other values (585)	121822	56.2%

Most occurring characters

Value	Count	Frequency (%)
a	228937	16.5%
s	111699	8.0%
u	89280	6.4%
g	89233	6.4%
o	85515	6.1%
C	82588	5.9%
e	81172	5.8%
n	76231	5.5%
l	60937	4.4%
i	60636	4.4%
Other values (42)	425325	30.6%

Most occurring categories

Value	Count	Frequency (%)
Lowercase Letter	1138231	81.8%
Uppercase Letter	216922	15.6%
Space Separator	36400	2.6%

Most frequent character per category

Lowercase Letter

Value	Count	Frequency (%)
a	228937	20.1%
s	111699	9.8%
u	89280	7.8%
g	89233	7.8%
o	85515	7.5%
e	81172	7.1%
n	76231	6.7%
l	60937	5.4%
i	60636	5.3%
r	57370	5.0%
Other values (16)	197221	17.3%

Uppercase Letter

Value	Count	Frequency (%)
C	82588	38.1%
S	14019	6.5%
B	13944	6.4%
L	13048	6.0%
A	10848	5.0%
P	10565	4.9%
M	9378	4.3%
H	8518	3.9%
D	5758	2.7%
N	5664	2.6%
Other values (15)	42592	19.6%

Space Separator

Value	Count	Frequency (%)
	36400	100.0%

Most occurring scripts

Value	Count	Frequency (%)
Latin	1355153	97.4%
Common	36400	2.6%

Most frequent character per script

Latin

Value	Count	Frequency (%)
a	228937	16.9%
s	111699	8.2%
u	89280	6.6%
g	89233	6.6%
o	85515	6.3%
C	82588	6.1%
e	81172	6.0%
n	76231	5.6%
l	60937	4.5%
i	60636	4.5%
Other values (41)	388925	28.7%

Common

Value	Count	Frequency (%)
	36400	100.0%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	1391553	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
a	228937	16.5%
s	111699	8.0%
u	89280	6.4%
g	89233	6.4%
o	85515	6.1%
C	82588	5.9%
e	81172	5.8%
n	76231	5.5%
l	60937	4.4%
i	60636	4.4%
Other values (42)	425325	30.6%

customer_country
Categorical

Distinct	2
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	1.4 MiB

EE. UU.	111146
Puerto Rico	69373

Length

Max length	11
Median length	7
Mean length	8.53719
Min length	7

Characters and Unicode

Total characters	1541125
Distinct characters	13
Distinct categories	4 ?
Distinct scripts	2 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	Puerto Rico
2nd row	Puerto Rico
3rd row	EE. UU.
4th row	EE. UU.
5th row	Puerto Rico

Common Values

Value	Count	Frequency (%)
EE. UU.	111146	61.6%
Puerto Rico	69373	38.4%

Length

Histogram of lengths of the category

Common Values (Plot)

Value	Count	Frequency (%)
ee	111146	30.8%
uu	111146	30.8%
puerto	69373	19.2%
rico	69373	19.2%

Most occurring characters

Value	Count	Frequency (%)
E	222292	14.4%
.	222292	14.4%
U	222292	14.4%
	180519	11.7%
o	138746	9.0%
P	69373	4.5%
u	69373	4.5%
e	69373	4.5%
r	69373	4.5%
t	69373	4.5%
Other values (3)	208119	13.5%

Most occurring categories

Value	Count	Frequency (%)
Uppercase Letter	583330	37.9%
Lowercase Letter	554984	36.0%
Other Punctuation	222292	14.4%
Space Separator	180519	11.7%

Most frequent character per category

Lowercase Letter

Value	Count	Frequency (%)
o	138746	25.0%
u	69373	12.5%
e	69373	12.5%
r	69373	12.5%
t	69373	12.5%
i	69373	12.5%
c	69373	12.5%

Uppercase Letter

Value	Count	Frequency (%)
E	222292	38.1%
U	222292	38.1%
P	69373	11.9%
R	69373	11.9%

Other Punctuation

Value	Count	Frequency (%)
.	222292	100.0%

Space Separator

Value	Count	Frequency (%)
	180519	100.0%

Most occurring scripts

Value	Count	Frequency (%)
Latin	1138314	73.9%
Common	402811	26.1%

Most frequent character per script

Latin

Value	Count	Frequency (%)
E	222292	19.5%
U	222292	19.5%
o	138746	12.2%
P	69373	6.1%
u	69373	6.1%
e	69373	6.1%
r	69373	6.1%
t	69373	6.1%
R	69373	6.1%
i	69373	6.1%

Common

Value	Count	Frequency (%)
.	222292	55.2%
	180519	44.8%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	1541125	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
E	222292	14.4%
.	222292	14.4%
U	222292	14.4%
	180519	11.7%
o	138746	9.0%
P	69373	4.5%
u	69373	4.5%
e	69373	4.5%
r	69373	4.5%
t	69373	4.5%
Other values (3)	208119	13.5%

customer_email
Categorical

Distinct	1
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	1.4 MiB

XXXXXXXXX	180519

Length

Max length	9
Median length	9
Mean length	9
Min length	9

Characters and Unicode

Total characters	1624671
Distinct characters	1
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	XXXXXXXXX
2nd row	XXXXXXXXX
3rd row	XXXXXXXXX
4th row	XXXXXXXXX
5th row	XXXXXXXXX

Common Values

Value	Count	Frequency (%)
XXXXXXXXX	180519	100.0%

Length

Histogram of lengths of the category

Common Values (Plot)

Value	Count	Frequency (%)
xxxxxxxxx	180519	100.0%

Most occurring characters

Value	Count	Frequency (%)
X	1624671	100.0%

Most occurring categories

Value	Count	Frequency (%)
Uppercase Letter	1624671	100.0%

Most frequent character per category

Uppercase Letter

Value	Count	Frequency (%)
X	1624671	100.0%

Most occurring scripts

Value	Count	Frequency (%)
Latin	1624671	100.0%

Most frequent character per script

Latin

Value	Count	Frequency (%)
X	1624671	100.0%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	1624671	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
X	1624671	100.0%

customer_fname
Categorical

Distinct	782
Distinct (%)	0.4%
Missing	0
Missing (%)	0.0%
Memory size	1.4 MiB

Mary	65150
James	1835
Robert	1759
Michael	1680
David	1625
Other values (777)	108470

Length

Max length	11
Median length	10
Mean length	5.2746581
Min length	2

Characters and Unicode

Total characters	952176
Distinct characters	52
Distinct categories	2 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	48 ?
Unique (%)	< 0.1%

Sample

1st row	Cally
2nd row	Irene
3rd row	Gillian
4th row	Tana
5th row	Orli

Common Values

Value	Count	Frequency (%)
Mary	65150	36.1%
James	1835	1.0%
Robert	1759	1.0%
Michael	1680	0.9%
David	1625	0.9%
John	1446	0.8%
William	1365	0.8%
Joseph	1117	0.6%
Jennifer	1033	0.6%
Richard	1032	0.6%
Other values (772)	102477	56.8%

Length

Histogram of lengths of the category

Value	Count	Frequency (%)
mary	65150	36.1%
james	1835	1.0%
robert	1759	1.0%
michael	1680	0.9%
david	1625	0.9%
john	1446	0.8%
william	1365	0.8%
joseph	1117	0.6%
jennifer	1033	0.6%
richard	1032	0.6%
Other values (771)	102477	56.8%

Most occurring characters

Value	Count	Frequency (%)
a	153270	16.1%
r	117429	12.3%
y	88689	9.3%
M	74129	7.8%
e	72908	7.7%
n	54931	5.8%
i	46547	4.9%
l	35613	3.7%
h	34074	3.6%
t	29586	3.1%
Other values (42)	245000	25.7%

Most occurring categories

Value	Count	Frequency (%)
Lowercase Letter	771639	81.0%
Uppercase Letter	180537	19.0%

Most frequent character per category

Lowercase Letter

Value	Count	Frequency (%)
a	153270	19.9%
r	117429	15.2%
y	88689	11.5%
e	72908	9.4%
n	54931	7.1%
i	46547	6.0%
l	35613	4.6%
h	34074	4.4%
t	29586	3.8%
o	28643	3.7%
Other values (16)	109949	14.2%

Uppercase Letter

Value	Count	Frequency (%)
M	74129	41.1%
J	17904	9.9%
A	9925	5.5%
D	9002	5.0%
R	8843	4.9%
S	8325	4.6%
C	7590	4.2%
K	6357	3.5%
B	6086	3.4%
E	4836	2.7%
Other values (16)	27540	15.3%

Most occurring scripts

Value	Count	Frequency (%)
Latin	952176	100.0%

Most frequent character per script

Latin

Value	Count	Frequency (%)
a	153270	16.1%
r	117429	12.3%
y	88689	9.3%
M	74129	7.8%
e	72908	7.7%
n	54931	5.8%
i	46547	4.9%
l	35613	3.7%
h	34074	3.6%
t	29586	3.1%
Other values (42)	245000	25.7%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	952176	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
a	153270	16.1%
r	117429	12.3%
y	88689	9.3%
M	74129	7.8%
e	72908	7.7%
n	54931	5.8%
i	46547	4.9%
l	35613	3.7%
h	34074	3.6%
t	29586	3.1%
Other values (42)	245000	25.7%

customer_id
Real number (ℝ)

Distinct	20652
Distinct (%)	11.4%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	6691.3795

Minimum	1
Maximum	20757
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	1.4 MiB

Quantile statistics

Minimum	1
5-th percentile	649
Q1	3258.5
median	6457
Q3	9779
95-th percentile	12383
Maximum	20757
Range	20756
Interquartile range (IQR)	6520.5

Descriptive statistics

Standard deviation	4162.9181
Coefficient of variation (CV)	0.62213152
Kurtosis	0.014898822
Mean	6691.3795
Median Absolute Deviation (MAD)	3263
Skewness	0.48876825
Sum	1.2079211 × 10⁹
Variance	17329887
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
5654	47	< 0.1%
10591	45	< 0.1%
5004	45	< 0.1%
5715	44	< 0.1%
3708	44	< 0.1%
9371	44	< 0.1%
1443	43	< 0.1%
791	43	< 0.1%
12284	43	< 0.1%
2641	43	< 0.1%
Other values (20642)	180078	99.8%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
1	1	< 0.1%
2	10	< 0.1%
3	18	< 0.1%
4	14	< 0.1%
5	7	< 0.1%
6	15	< 0.1%
7	22	< 0.1%
8	19	< 0.1%
9	14	< 0.1%
10	8	< 0.1%

Value	Count	Frequency (%)
20757	1	< 0.1%
20756	1	< 0.1%
20755	1	< 0.1%
20754	1	< 0.1%
20753	1	< 0.1%
20752	1	< 0.1%
20751	1	< 0.1%
20750	1	< 0.1%
20749	1	< 0.1%
20748	1	< 0.1%

customer_lname
Categorical

Distinct	1109
Distinct (%)	0.6%
Missing	8
Missing (%)	< 0.1%
Memory size	1.4 MiB

Smith	64104
Johnson	989
Brown	909
Williams	869
Jones	859
Other values (1104)	112781

Length

Max length	12
Median length	11
Mean length	5.7124109
Min length	2

Characters and Unicode

Total characters	1031153
Distinct characters	51
Distinct categories	2 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	29 ?
Unique (%)	< 0.1%

Sample

1st row	Holloway
2nd row	Luna
3rd row	Maldonado
4th row	Tate
5th row	Hendricks

Common Values

Value	Count	Frequency (%)
Smith	64104	35.5%
Johnson	989	0.5%
Brown	909	0.5%
Williams	869	0.5%
Jones	859	0.5%
Garcia	724	0.4%
Wilson	675	0.4%
Taylor	661	0.4%
Davis	640	0.4%
Moore	599	0.3%
Other values (1099)	109482	60.6%

Length

Histogram of lengths of the category

Value	Count	Frequency (%)
smith	64104	35.5%
johnson	989	0.5%
brown	909	0.5%
williams	869	0.5%
jones	859	0.5%
garcia	724	0.4%
wilson	675	0.4%
taylor	661	0.4%
davis	640	0.4%
moore	599	0.3%
Other values (1099)	109482	60.7%

Most occurring characters

Value	Count	Frequency (%)
i	98958	9.6%
t	89337	8.7%
h	80056	7.8%
m	76994	7.5%
S	72853	7.1%
e	71442	6.9%
r	61613	6.0%
a	60479	5.9%
n	60324	5.9%
o	54728	5.3%
Other values (41)	304369	29.5%

Most occurring categories

Value	Count	Frequency (%)
Lowercase Letter	850642	82.5%
Uppercase Letter	180511	17.5%

Most frequent character per category

Lowercase Letter

Value	Count	Frequency (%)
i	98958	11.6%
t	89337	10.5%
h	80056	9.4%
m	76994	9.1%
e	71442	8.4%
r	61613	7.2%
a	60479	7.1%
n	60324	7.1%
o	54728	6.4%
l	41923	4.9%
Other values (16)	154788	18.2%

Uppercase Letter

Value	Count	Frequency (%)
S	72853	40.4%
M	12703	7.0%
H	10338	5.7%
B	9912	5.5%
C	9589	5.3%
W	8613	4.8%
R	7704	4.3%
G	6598	3.7%
P	6470	3.6%
L	4992	2.8%
Other values (15)	30739	17.0%

Most occurring scripts

Value	Count	Frequency (%)
Latin	1031153	100.0%

Most frequent character per script

Latin

Value	Count	Frequency (%)
i	98958	9.6%
t	89337	8.7%
h	80056	7.8%
m	76994	7.5%
S	72853	7.1%
e	71442	6.9%
r	61613	6.0%
a	60479	5.9%
n	60324	5.9%
o	54728	5.3%
Other values (41)	304369	29.5%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	1031153	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
i	98958	9.6%
t	89337	8.7%
h	80056	7.8%
m	76994	7.5%
S	72853	7.1%
e	71442	6.9%
r	61613	6.0%
a	60479	5.9%
n	60324	5.9%
o	54728	5.3%
Other values (41)	304369	29.5%

customer_password
Categorical

Distinct	1
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	1.4 MiB

XXXXXXXXX	180519

Length

Max length	9
Median length	9
Mean length	9
Min length	9

Characters and Unicode

Total characters	1624671
Distinct characters	1
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	XXXXXXXXX
2nd row	XXXXXXXXX
3rd row	XXXXXXXXX
4th row	XXXXXXXXX
5th row	XXXXXXXXX

Common Values

Value	Count	Frequency (%)
XXXXXXXXX	180519	100.0%

Length

Histogram of lengths of the category

Common Values (Plot)

Value	Count	Frequency (%)
xxxxxxxxx	180519	100.0%

Most occurring characters

Value	Count	Frequency (%)
X	1624671	100.0%

Most occurring categories

Value	Count	Frequency (%)
Uppercase Letter	1624671	100.0%

Most frequent character per category

Uppercase Letter

Value	Count	Frequency (%)
X	1624671	100.0%

Most occurring scripts

Value	Count	Frequency (%)
Latin	1624671	100.0%

Most frequent character per script

Latin

Value	Count	Frequency (%)
X	1624671	100.0%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	1624671	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
X	1624671	100.0%

customer_segment
Categorical

Distinct	3
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	1.4 MiB

Consumer	93504
Corporate	54789
Home Office	32226

Length

Max length	11
Median length	8
Mean length	8.839064
Min length	8

Characters and Unicode

Total characters	1595619
Distinct characters	17
Distinct categories	3 ?
Distinct scripts	2 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	Consumer
2nd row	Consumer
3rd row	Consumer
4th row	Home Office
5th row	Corporate

Common Values

Value	Count	Frequency (%)
Consumer	93504	51.8%
Corporate	54789	30.4%
Home Office	32226	17.9%

Length

Histogram of lengths of the category

Common Values (Plot)

Value	Count	Frequency (%)
consumer	93504	44.0%
corporate	54789	25.8%
home	32226	15.1%
office	32226	15.1%

Most occurring characters

Value	Count	Frequency (%)
o	235308	14.7%
e	212745	13.3%
r	203082	12.7%
C	148293	9.3%
m	125730	7.9%
n	93504	5.9%
s	93504	5.9%
u	93504	5.9%
f	64452	4.0%
t	54789	3.4%
Other values (7)	270708	17.0%

Most occurring categories

Value	Count	Frequency (%)
Lowercase Letter	1350648	84.6%
Uppercase Letter	212745	13.3%
Space Separator	32226	2.0%

Most frequent character per category

Lowercase Letter

Value	Count	Frequency (%)
o	235308	17.4%
e	212745	15.8%
r	203082	15.0%
m	125730	9.3%
n	93504	6.9%
s	93504	6.9%
u	93504	6.9%
f	64452	4.8%
t	54789	4.1%
p	54789	4.1%
Other values (3)	119241	8.8%

Uppercase Letter

Value	Count	Frequency (%)
C	148293	69.7%
H	32226	15.1%
O	32226	15.1%

Space Separator

Value	Count	Frequency (%)
	32226	100.0%

Most occurring scripts

Value	Count	Frequency (%)
Latin	1563393	98.0%
Common	32226	2.0%

Most frequent character per script

Latin

Value	Count	Frequency (%)
o	235308	15.1%
e	212745	13.6%
r	203082	13.0%
C	148293	9.5%
m	125730	8.0%
n	93504	6.0%
s	93504	6.0%
u	93504	6.0%
f	64452	4.1%
t	54789	3.5%
Other values (6)	238482	15.3%

Common

Value	Count	Frequency (%)
	32226	100.0%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	1595619	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
o	235308	14.7%
e	212745	13.3%
r	203082	12.7%
C	148293	9.3%
m	125730	7.9%
n	93504	5.9%
s	93504	5.9%
u	93504	5.9%
f	64452	4.0%
t	54789	3.4%
Other values (7)	270708	17.0%

customer_state
Categorical

Distinct	46
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	1.4 MiB

PR	69373
CA	29223
NY	11327
TX	9103
IL	7631
Other values (41)	53862

Length

Max length	5
Median length	2
Mean length	2.0000499
Min length	2

Characters and Unicode

Total characters	361047
Distinct characters	31
Distinct categories	2 ?
Distinct scripts	2 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	1 ?
Unique (%)	< 0.1%

Sample

1st row	PR
2nd row	PR
3rd row	CA
4th row	CA
5th row	PR

Common Values

Value	Count	Frequency (%)
PR	69373	38.4%
CA	29223	16.2%
NY	11327	6.3%
TX	9103	5.0%
IL	7631	4.2%
FL	5456	3.0%
OH	4095	2.3%
PA	3824	2.1%
MI	3804	2.1%
NJ	3191	1.8%
Other values (36)	33492	18.6%

Length

Histogram of lengths of the category

Value	Count	Frequency (%)
pr	69373	38.4%
ca	29223	16.2%
ny	11327	6.3%
tx	9103	5.0%
il	7631	4.2%
fl	5456	3.0%
oh	4095	2.3%
pa	3824	2.1%
mi	3804	2.1%
nj	3191	1.8%
Other values (36)	33492	18.6%

Most occurring characters

Value	Count	Frequency (%)
P	73197	20.3%
R	71448	19.8%
A	44166	12.2%
C	35467	9.8%
N	21949	6.1%
I	14591	4.0%
L	14070	3.9%
T	12834	3.6%
Y	11814	3.3%
M	10888	3.0%
Other values (21)	50623	14.0%

Most occurring categories

Value	Count	Frequency (%)
Uppercase Letter	361032	> 99.9%
Decimal Number	15	< 0.1%

Most frequent character per category

Uppercase Letter

Value	Count	Frequency (%)
P	73197	20.3%
R	71448	19.8%
A	44166	12.2%
C	35467	9.8%
N	21949	6.1%
I	14591	4.0%
L	14070	3.9%
T	12834	3.6%
Y	11814	3.3%
M	10888	3.0%
Other values (14)	50608	14.0%

Decimal Number

Value	Count	Frequency (%)
5	4	26.7%
9	3	20.0%
7	3	20.0%
8	2	13.3%
1	1	6.7%
3	1	6.7%
2	1	6.7%

Most occurring scripts

Value	Count	Frequency (%)
Latin	361032	> 99.9%
Common	15	< 0.1%

Most frequent character per script

Latin

Value	Count	Frequency (%)
P	73197	20.3%
R	71448	19.8%
A	44166	12.2%
C	35467	9.8%
N	21949	6.1%
I	14591	4.0%
L	14070	3.9%
T	12834	3.6%
Y	11814	3.3%
M	10888	3.0%
Other values (14)	50608	14.0%

Common

Value	Count	Frequency (%)
5	4	26.7%
9	3	20.0%
7	3	20.0%
8	2	13.3%
1	1	6.7%
3	1	6.7%
2	1	6.7%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	361047	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
P	73197	20.3%
R	71448	19.8%
A	44166	12.2%
C	35467	9.8%
N	21949	6.1%
I	14591	4.0%
L	14070	3.9%
T	12834	3.6%
Y	11814	3.3%
M	10888	3.0%
Other values (21)	50623	14.0%

customer_street
Categorical

Distinct	7458
Distinct (%)	4.1%
Missing	0
Missing (%)	0.0%
Memory size	1.4 MiB

9126 Wishing Expressway	122
4388 Burning Goose Ridge	117
4720 Noble Hills Wynd	116
2878 Hazy Wagon Thicket	113
398 Emerald Grove	109
Other values (7453)	179942

Length

Max length	33
Median length	28
Mean length	19.957113
Min length	8

Characters and Unicode

Total characters	3602638
Distinct characters	61
Distinct categories	5 ?
Distinct scripts	2 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	483 ?
Unique (%)	0.3%

Sample

1st row	5365 Noble Nectar Island
2nd row	2679 Rustic Loop
3rd row	8510 Round Bear Gate
4th row	3200 Amber Bend
5th row	8671 Iron Anchor Corners

Common Values

Value	Count	Frequency (%)
9126 Wishing Expressway	122	0.1%
4388 Burning Goose Ridge	117	0.1%
4720 Noble Hills Wynd	116	0.1%
2878 Hazy Wagon Thicket	113	0.1%
398 Emerald Grove	109	0.1%
3593 Blue Brook Acres	108	0.1%
2210 Merry Leaf Row	107	0.1%
6289 Rocky Way	107	0.1%
2585 Silent Autumn Landing	105	0.1%
7694 Velvet Turnabout	103	0.1%
Other values (7448)	179412	99.4%

Length

Histogram of lengths of the category

Value	Count	Frequency (%)
green	4491	0.7%
round	4181	0.7%
golden	3710	0.6%
clear	3684	0.6%
rustic	3659	0.6%
thunder	3616	0.6%
honey	3604	0.6%
velvet	3538	0.6%
heather	3513	0.6%
misty	3508	0.6%
Other values (3299)	592865	94.1%

Most occurring characters

Value	Count	Frequency (%)
	452905	12.6%
e	266514	7.4%
a	188658	5.2%
n	172491	4.8%
r	166038	4.6%
o	162182	4.5%
l	132873	3.7%
i	132088	3.7%
t	117744	3.3%
s	101650	2.8%
Other values (51)	1709495	47.5%

Most occurring categories

Value	Count	Frequency (%)
Lowercase Letter	1995175	55.4%
Decimal Number	703140	19.5%
Space Separator	452905	12.6%
Uppercase Letter	449853	12.5%
Dash Punctuation	1565	< 0.1%

Most frequent character per category

Lowercase Letter

Value	Count	Frequency (%)
e	266514	13.4%
a	188658	9.5%
n	172491	8.6%
r	166038	8.3%
o	162182	8.1%
l	132873	6.7%
i	132088	6.6%
t	117744	5.9%
s	101650	5.1%
d	90014	4.5%
Other values (15)	464923	23.3%

Uppercase Letter

Value	Count	Frequency (%)
C	48068	10.7%
B	36535	8.1%
H	34142	7.6%
R	31731	7.1%
P	31630	7.0%
S	29549	6.6%
L	27209	6.0%
G	26549	5.9%
M	22218	4.9%
F	20196	4.5%
Other values (14)	142026	31.6%

Decimal Number

Value	Count	Frequency (%)
7	75478	10.7%
1	74531	10.6%
9	74093	10.5%
4	72421	10.3%
3	71753	10.2%
5	71310	10.1%
2	70868	10.1%
6	70687	10.1%
8	69639	9.9%
0	52360	7.4%

Space Separator

Value	Count	Frequency (%)
	452905	100.0%

Dash Punctuation

Value	Count	Frequency (%)
-	1565	100.0%

Most occurring scripts

Value	Count	Frequency (%)
Latin	2445028	67.9%
Common	1157610	32.1%

Most frequent character per script

Latin

Value	Count	Frequency (%)
e	266514	10.9%
a	188658	7.7%
n	172491	7.1%
r	166038	6.8%
o	162182	6.6%
l	132873	5.4%
i	132088	5.4%
t	117744	4.8%
s	101650	4.2%
d	90014	3.7%
Other values (39)	914776	37.4%

Common

Value	Count	Frequency (%)
	452905	39.1%
7	75478	6.5%
1	74531	6.4%
9	74093	6.4%
4	72421	6.3%
3	71753	6.2%
5	71310	6.2%
2	70868	6.1%
6	70687	6.1%
8	69639	6.0%
Other values (2)	53925	4.7%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	3602638	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
	452905	12.6%
e	266514	7.4%
a	188658	5.2%
n	172491	4.8%
r	166038	4.6%
o	162182	4.5%
l	132873	3.7%
i	132088	3.7%
t	117744	3.3%
s	101650	2.8%
Other values (51)	1709495	47.5%

customer_zipcode
Real number (ℝ)

Distinct	995
Distinct (%)	0.6%
Missing	3
Missing (%)	< 0.1%
Infinite	0
Infinite (%)	0.0%
Mean	35921.127

Minimum	603
Maximum	99205
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	1.4 MiB

Quantile statistics

Minimum	603
5-th percentile	725
Q1	725
median	19380
Q3	78207
95-th percentile	94538
Maximum	99205
Range	98602
Interquartile range (IQR)	77482

Descriptive statistics

Standard deviation	37542.461
Coefficient of variation (CV)	1.045136
Kurtosis	-1.4514194
Mean	35921.127
Median Absolute Deviation (MAD)	18655
Skewness	0.49088341
Sum	6.4843381 × 10⁹
Variance	1.4094364 × 10⁹
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
725	66770	37.0%
921	337	0.2%
23455	334	0.2%
957	297	0.2%
79109	292	0.2%
33324	283	0.2%
80012	280	0.2%
33624	261	0.1%
92115	256	0.1%
92024	254	0.1%
Other values (985)	111152	61.6%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
603	50	< 0.1%
612	122	0.1%
674	169	0.1%
680	133	0.1%
685	126	0.1%
693	140	0.1%
698	115	0.1%
725	66770	37.0%
728	22	< 0.1%
729	48	< 0.1%

Value	Count	Frequency (%)
99205	43	< 0.1%
98632	67	< 0.1%
98390	28	< 0.1%
98226	47	< 0.1%
98208	95	0.1%
98115	185	0.1%
98052	117	0.1%
98037	82	< 0.1%
98031	158	0.1%
98023	98	0.1%

department_id
Real number (ℝ)

Distinct	11
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	5.4434602

Minimum	2
Maximum	12
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	1.4 MiB

Quantile statistics

Minimum	2
5-th percentile	3
Q1	4
median	5
Q3	7
95-th percentile	7
Maximum	12
Range	10
Interquartile range (IQR)	3

Descriptive statistics

Standard deviation	1.629246
Coefficient of variation (CV)	0.29930338
Kurtosis	-0.18169651
Mean	5.4434602
Median Absolute Deviation (MAD)	1
Skewness	0.27332063
Sum	982648
Variance	2.6544426
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=11)

Value	Count	Frequency (%)
7	66861	37.0%
4	48998	27.1%
5	33220	18.4%
3	14525	8.0%
6	9686	5.4%
2	2479	1.4%
9	2026	1.1%
10	1465	0.8%
11	492	0.3%
8	405	0.2%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
2	2479	1.4%
3	14525	8.0%
4	48998	27.1%
5	33220	18.4%
6	9686	5.4%
7	66861	37.0%
8	405	0.2%
9	2026	1.1%
10	1465	0.8%
11	492	0.3%

Value	Count	Frequency (%)
12	362	0.2%
11	492	0.3%
10	1465	0.8%
9	2026	1.1%
8	405	0.2%
7	66861	37.0%
6	9686	5.4%
5	33220	18.4%
4	48998	27.1%
3	14525	8.0%

department_name
Categorical

Distinct	11
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	1.4 MiB

Fan Shop	66861
Apparel	48998
Golf	33220
Footwear	14525
Outdoors	9686
Other values (6)	7229

Length

Max length	18
Median length	8
Mean length	7.0397133
Min length	4

Characters and Unicode

Total characters	1270802
Distinct characters	30
Distinct categories	3 ?
Distinct scripts	2 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	Fitness
2nd row	Fitness
3rd row	Fitness
4th row	Fitness
5th row	Fitness

Common Values

Value	Count	Frequency (%)
Fan Shop	66861	37.0%
Apparel	48998	27.1%
Golf	33220	18.4%
Footwear	14525	8.0%
Outdoors	9686	5.4%
Fitness	2479	1.4%
Discs Shop	2026	1.1%
Technology	1465	0.8%
Pet Shop	492	0.3%
Book Shop	405	0.2%

Length

Histogram of lengths of the category

Value	Count	Frequency (%)
shop	69784	27.8%
fan	66861	26.6%
apparel	48998	19.5%
golf	33220	13.2%
footwear	14525	5.8%
outdoors	9686	3.9%
fitness	2479	1.0%
discs	2026	0.8%
technology	1465	0.6%
pet	492	0.2%
Other values (4)	1491	0.6%

Most occurring characters

Value	Count	Frequency (%)
p	167780	13.2%
o	155166	12.2%
a	131470	10.3%
l	84045	6.6%
F	83865	6.6%
r	73209	5.8%
h	71611	5.6%
n	71167	5.6%
	70870	5.6%
S	69784	5.5%
Other values (20)	291835	23.0%

Most occurring categories

Value	Count	Frequency (%)
Lowercase Letter	949267	74.7%
Uppercase Letter	250665	19.7%
Space Separator	70870	5.6%

Most frequent character per category

Lowercase Letter

Value	Count	Frequency (%)
p	167780	17.7%
o	155166	16.3%
a	131470	13.8%
l	84045	8.9%
r	73209	7.7%
h	71611	7.5%
n	71167	7.5%
e	68683	7.2%
f	33220	3.5%
t	27906	2.9%
Other values (9)	65010	6.8%

Uppercase Letter

Value	Count	Frequency (%)
F	83865	33.5%
S	69784	27.8%
A	48998	19.5%
G	33220	13.3%
O	9686	3.9%
D	2026	0.8%
T	1465	0.6%
B	767	0.3%
P	492	0.2%
H	362	0.1%

Space Separator

Value	Count	Frequency (%)
	70870	100.0%

Most occurring scripts

Value	Count	Frequency (%)
Latin	1199932	94.4%
Common	70870	5.6%

Most frequent character per script

Latin

Value	Count	Frequency (%)
p	167780	14.0%
o	155166	12.9%
a	131470	11.0%
l	84045	7.0%
F	83865	7.0%
r	73209	6.1%
h	71611	6.0%
n	71167	5.9%
S	69784	5.8%
e	68683	5.7%
Other values (19)	223152	18.6%

Common

Value	Count	Frequency (%)
	70870	100.0%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	1270802	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
p	167780	13.2%
o	155166	12.2%
a	131470	10.3%
l	84045	6.6%
F	83865	6.6%
r	73209	5.8%
h	71611	5.6%
n	71167	5.6%
	70870	5.6%
S	69784	5.5%
Other values (20)	291835	23.0%

latitude
Real number (ℝ)

Distinct	11250
Distinct (%)	6.2%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	29.719955

Minimum	-33.937553
Maximum	48.781933
Zeros	0
Zeros (%)	0.0%
Negative	9
Negative (%)	< 0.1%
Memory size	1.4 MiB

Quantile statistics

Minimum	-33.937553
5-th percentile	18.212931
Q1	18.265432
median	33.144863
Q3	39.279617
95-th percentile	42.391102
Maximum	48.781933
Range	82.719486
Interquartile range (IQR)	21.014185

Descriptive statistics

Standard deviation	9.8136463
Coefficient of variation (CV)	0.33020395
Kurtosis	-1.5554149
Mean	29.719955
Median Absolute Deviation (MAD)	8.3017807
Skewness	-0.097962666
Sum	5365016.5
Variance	96.307654
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
18.2275734	417	0.2%
39.49591446	370	0.2%
18.22757721	300	0.2%
36.91083145	280	0.2%
26.0984993	270	0.1%
18.38011932	267	0.1%
33.04647064	234	0.1%
26.21472931	218	0.1%
32.75856018	218	0.1%
40.64759827	212	0.1%
Other values (11240)	177733	98.5%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
-33.93755341	9	< 0.1%
17.98249054	38	< 0.1%
18.00682068	22	< 0.1%
18.01836205	20	< 0.1%
18.02520371	17	< 0.1%
18.02520943	10	< 0.1%
18.02523232	8	< 0.1%
18.02528	14	< 0.1%
18.02529907	30	< 0.1%
18.02535057	5	< 0.1%

Value	Count	Frequency (%)
48.78193283	6	< 0.1%
48.77095795	41	< 0.1%
47.92603684	7	< 0.1%
47.91250229	4	< 0.1%
47.90813828	20	< 0.1%
47.90808868	10	< 0.1%
47.88882828	61	< 0.1%
47.84322357	70	< 0.1%
47.83976364	15	< 0.1%
47.83055496	6	< 0.1%

longitude
Real number (ℝ)

Distinct	4487
Distinct (%)	2.5%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	-84.915675

Minimum	-158.02599
Maximum	115.26308
Zeros	0
Zeros (%)	0.0%
Negative	180414
Negative (%)	99.9%
Memory size	1.4 MiB

Quantile statistics

Minimum	-158.02599
5-th percentile	-121.43511
Q1	-98.446312
median	-76.847908
Q3	-66.370583
95-th percentile	-66.183128
Maximum	115.26308
Range	273.28906
Interquartile range (IQR)	32.075729

Descriptive statistics

Standard deviation	21.433241
Coefficient of variation (CV)	-0.25240618
Kurtosis	2.1809822
Mean	-84.915675
Median Absolute Deviation (MAD)	10.477371
Skewness	-0.49846107
Sum	-15328893
Variance	459.38383
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
-66.3706131	3821	2.1%
-66.37057495	3523	2.0%
-66.37059021	3522	2.0%
-66.37050629	3465	1.9%
-66.37055206	3417	1.9%
-66.37052918	3408	1.9%
-66.3705368	3377	1.9%
-66.37055969	3242	1.8%
-66.37060547	3230	1.8%
-66.37058258	3155	1.7%
Other values (4477)	146359	81.1%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
-158.0259857	73	< 0.1%
-158.016037	134	0.1%
-158.0102234	18	< 0.1%
-158.0047607	7	< 0.1%
-158.0046844	43	< 0.1%
-158.0046234	45	< 0.1%
-157.9980164	40	< 0.1%
-157.997879	46	< 0.1%
-157.906601	60	< 0.1%
-157.8772125	35	< 0.1%

Value	Count	Frequency (%)
115.2630768	17	< 0.1%
115.0497894	17	< 0.1%
84.74267578	8	< 0.1%
82.46199799	22	< 0.1%
77.09209442	32	< 0.1%
18.57143784	9	< 0.1%
-12.1069355	9	< 0.1%
-12.13093758	33	< 0.1%
-12.13232708	11	< 0.1%
-12.25018311	18	< 0.1%

market
Categorical

Distinct	5
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	1.4 MiB

LATAM	51594
Europe	50252
Pacific Asia	41260
USCA	25799
Africa	11614

Length

Max length	12
Median length	6
Mean length	6.7997385
Min length	4

Characters and Unicode

Total characters	1227482
Distinct characters	20
Distinct categories	3 ?
Distinct scripts	2 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	Pacific Asia
2nd row	Pacific Asia
3rd row	Pacific Asia
4th row	Pacific Asia
5th row	Pacific Asia

Common Values

Value	Count	Frequency (%)
LATAM	51594	28.6%
Europe	50252	27.8%
Pacific Asia	41260	22.9%
USCA	25799	14.3%
Africa	11614	6.4%

Length

Histogram of lengths of the category

Common Values (Plot)

Value	Count	Frequency (%)
latam	51594	23.3%
europe	50252	22.7%
pacific	41260	18.6%
asia	41260	18.6%
usca	25799	11.6%
africa	11614	5.2%

Most occurring characters

Value	Count	Frequency (%)
A	181861	14.8%
i	135394	11.0%
a	94134	7.7%
c	94134	7.7%
r	61866	5.0%
f	52874	4.3%
L	51594	4.2%
T	51594	4.2%
M	51594	4.2%
E	50252	4.1%
Other values (10)	402185	32.8%

Most occurring categories

Value	Count	Frequency (%)
Lowercase Letter	680670	55.5%
Uppercase Letter	505552	41.2%
Space Separator	41260	3.4%

Most frequent character per category

Lowercase Letter

Value	Count	Frequency (%)
i	135394	19.9%
a	94134	13.8%
c	94134	13.8%
r	61866	9.1%
f	52874	7.8%
u	50252	7.4%
o	50252	7.4%
p	50252	7.4%
e	50252	7.4%
s	41260	6.1%

Uppercase Letter

Value	Count	Frequency (%)
A	181861	36.0%
L	51594	10.2%
T	51594	10.2%
M	51594	10.2%
E	50252	9.9%
P	41260	8.2%
U	25799	5.1%
S	25799	5.1%
C	25799	5.1%

Space Separator

Value	Count	Frequency (%)
	41260	100.0%

Most occurring scripts

Value	Count	Frequency (%)
Latin	1186222	96.6%
Common	41260	3.4%

Most frequent character per script

Latin

Value	Count	Frequency (%)
A	181861	15.3%
i	135394	11.4%
a	94134	7.9%
c	94134	7.9%
r	61866	5.2%
f	52874	4.5%
L	51594	4.3%
T	51594	4.3%
M	51594	4.3%
E	50252	4.2%
Other values (9)	360925	30.4%

Common

Value	Count	Frequency (%)
	41260	100.0%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	1227482	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
A	181861	14.8%
i	135394	11.0%
a	94134	7.7%
c	94134	7.7%
r	61866	5.0%
f	52874	4.3%
L	51594	4.2%
T	51594	4.2%
M	51594	4.2%
E	50252	4.1%
Other values (10)	402185	32.8%

order_city
Categorical

Distinct	3597
Distinct (%)	2.0%
Missing	0
Missing (%)	0.0%
Memory size	1.4 MiB

Santo Domingo	2211
New York City	2202
Los Angeles	1845
Tegucigalpa	1783
Managua	1682
Other values (3592)	170796

Length

Max length	35
Median length	29
Mean length	8.5542131
Min length	2

Characters and Unicode

Total characters	1544198
Distinct characters	79
Distinct categories	8 ?
Distinct scripts	2 ?
Distinct blocks	2 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	69 ?
Unique (%)	< 0.1%

Sample

1st row	Bekasi
2nd row	Bikaner
3rd row	Bikaner
4th row	Townsville
5th row	Townsville

Common Values

Value	Count	Frequency (%)
Santo Domingo	2211	1.2%
New York City	2202	1.2%
Los Angeles	1845	1.0%
Tegucigalpa	1783	1.0%
Managua	1682	0.9%
Mexico City	1484	0.8%
Manila	1381	0.8%
Philadelphia	1302	0.7%
San Francisco	1297	0.7%
London	1187	0.7%
Other values (3587)	164145	90.9%

Length

Histogram of lengths of the category

Value	Count	Frequency (%)
san	6508	2.9%
city	5626	2.5%
de	3211	1.4%
los	2435	1.1%
santo	2339	1.0%
new	2316	1.0%
york	2316	1.0%
domingo	2239	1.0%
angeles	1857	0.8%
tegucigalpa	1783	0.8%
Other values (3768)	197270	86.6%

Most occurring characters

Value	Count	Frequency (%)
a	197677	12.8%
e	116504	7.5%
n	115087	7.5%
o	111297	7.2%
i	94427	6.1%
r	85703	5.6%
l	76707	5.0%
u	57916	3.8%
t	56384	3.7%
s	56123	3.6%
Other values (69)	576373	37.3%

Most occurring categories

Value	Count	Frequency (%)
Lowercase Letter	1264434	81.9%
Uppercase Letter	225693	14.6%
Space Separator	47381	3.1%
Dash Punctuation	5982	0.4%
Other Punctuation	659	< 0.1%
Open Punctuation	21	< 0.1%
Close Punctuation	21	< 0.1%
Control	7	< 0.1%

Most frequent character per category

Lowercase Letter

Value	Count	Frequency (%)
a	197677	15.6%
e	116504	9.2%
n	115087	9.1%
o	111297	8.8%
i	94427	7.5%
r	85703	6.8%
l	76707	6.1%
u	57916	4.6%
t	56384	4.5%
s	56123	4.4%
Other values (32)	296609	23.5%

Uppercase Letter

Value	Count	Frequency (%)
S	28079	12.4%
C	25625	11.4%
M	23445	10.4%
B	16591	7.4%
P	15223	6.7%
L	14772	6.5%
A	13507	6.0%
T	10236	4.5%
D	9031	4.0%
N	7965	3.5%
Other values (19)	61219	27.1%

Other Punctuation

Value	Count	Frequency (%)
'	509	77.2%
?	137	20.8%
.	13	2.0%

Space Separator

Value	Count	Frequency (%)
	47381	100.0%

Dash Punctuation

Value	Count	Frequency (%)
-	5982	100.0%

Open Punctuation

Value	Count	Frequency (%)
(	21	100.0%

Close Punctuation

Value	Count	Frequency (%)
)	21	100.0%

Control

Value	Count	Frequency (%)
	7	100.0%

Most occurring scripts

Value	Count	Frequency (%)
Latin	1490127	96.5%
Common	54071	3.5%

Most frequent character per script

Latin

Value	Count	Frequency (%)
a	197677	13.3%
e	116504	7.8%
n	115087	7.7%
o	111297	7.5%
i	94427	6.3%
r	85703	5.8%
l	76707	5.1%
u	57916	3.9%
t	56384	3.8%
s	56123	3.8%
Other values (61)	522302	35.1%

Common

Value	Count	Frequency (%)
	47381	87.6%
-	5982	11.1%
'	509	0.9%
?	137	0.3%
(	21	< 0.1%
)	21	< 0.1%
.	13	< 0.1%
	7	< 0.1%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	1528572	99.0%
None	15626	1.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
a	197677	12.9%
e	116504	7.6%
n	115087	7.5%
o	111297	7.3%
i	94427	6.2%
r	85703	5.6%
l	76707	5.0%
u	57916	3.8%
t	56384	3.7%
s	56123	3.7%
Other values (49)	560747	36.7%

None

Value	Count	Frequency (%)
í	4201	26.9%
á	4180	26.8%
ó	2167	13.9%
é	1466	9.4%
ã	1354	8.7%
ú	1170	7.5%
ç	279	1.8%
ü	259	1.7%
ñ	166	1.1%
Á	148	0.9%
Other values (10)	236	1.5%

order_country
Categorical

Distinct	164
Distinct (%)	0.1%
Missing	0
Missing (%)	0.0%
Memory size	1.4 MiB

Estados Unidos	24840
Francia	13222
México	13172
Alemania	9564
Australia	8497
Other values (159)	111224

Length

Max length	31
Median length	22
Mean length	8.7728272
Min length	4

Characters and Unicode

Total characters	1583662
Distinct characters	61
Distinct categories	6 ?
Distinct scripts	2 ?
Distinct blocks	2 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	2 ?
Unique (%)	< 0.1%

Sample

1st row	Indonesia
2nd row	India
3rd row	India
4th row	Australia
5th row	Australia

Common Values

Value	Count	Frequency (%)
Estados Unidos	24840	13.8%
Francia	13222	7.3%
México	13172	7.3%
Alemania	9564	5.3%
Australia	8497	4.7%
Brasil	7987	4.4%
Reino Unido	7302	4.0%
China	5758	3.2%
Italia	4989	2.8%
India	4783	2.6%
Other values (154)	80405	44.5%

Length

Histogram of lengths of the category

Value	Count	Frequency (%)
unidos	24869	10.8%
estados	24840	10.8%
francia	13222	5.7%
méxico	13172	5.7%
alemania	9564	4.1%
australia	8497	3.7%
brasil	7987	3.5%
reino	7302	3.2%
unido	7302	3.2%
china	5758	2.5%
Other values (175)	108034	46.9%

Most occurring characters

Value	Count	Frequency (%)
a	241810	15.3%
i	166236	10.5%
n	119798	7.6%
s	117962	7.4%
o	109660	6.9%
d	83403	5.3%
r	66669	4.2%
l	62119	3.9%
e	53254	3.4%
t	50532	3.2%
Other values (51)	512219	32.3%

Most occurring categories

Value	Count	Frequency (%)
Lowercase Letter	1303170	82.3%
Uppercase Letter	229618	14.5%
Space Separator	50028	3.2%
Open Punctuation	409	< 0.1%
Close Punctuation	409	< 0.1%
Dash Punctuation	28	< 0.1%

Most frequent character per category

Lowercase Letter

Value	Count	Frequency (%)
a	241810	18.6%
i	166236	12.8%
n	119798	9.2%
s	117962	9.1%
o	109660	8.4%
d	83403	6.4%
r	66669	5.1%
l	62119	4.8%
e	53254	4.1%
t	50532	3.9%
Other values (22)	231727	17.8%

Uppercase Letter

Value	Count	Frequency (%)
E	34032	14.8%
U	33494	14.6%
A	24433	10.6%
I	17168	7.5%
M	16328	7.1%
F	15635	6.8%
C	15397	6.7%
R	13800	6.0%
B	12369	5.4%
S	8781	3.8%
Other values (15)	38181	16.6%

Space Separator

Value	Count	Frequency (%)
	50028	100.0%

Open Punctuation

Value	Count	Frequency (%)
(	409	100.0%

Close Punctuation

Value	Count	Frequency (%)
)	409	100.0%

Dash Punctuation

Value	Count	Frequency (%)
-	28	100.0%

Most occurring scripts

Value	Count	Frequency (%)
Latin	1532788	96.8%
Common	50874	3.2%

Most frequent character per script

Latin

Value	Count	Frequency (%)
a	241810	15.8%
i	166236	10.8%
n	119798	7.8%
s	117962	7.7%
o	109660	7.2%
d	83403	5.4%
r	66669	4.3%
l	62119	4.1%
e	53254	3.5%
t	50532	3.3%
Other values (47)	461345	30.1%

Common

Value	Count	Frequency (%)
	50028	98.3%
(	409	0.8%
)	409	0.8%
-	28	0.1%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	1545222	97.6%
None	38440	2.4%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
a	241810	15.6%
i	166236	10.8%
n	119798	7.8%
s	117962	7.6%
o	109660	7.1%
d	83403	5.4%
r	66669	4.3%
l	62119	4.0%
e	53254	3.4%
t	50532	3.3%
Other values (44)	473779	30.7%

None

Value	Count	Frequency (%)
é	14306	37.2%
í	7138	18.6%
á	6253	16.3%
ú	6043	15.7%
ñ	3868	10.1%
ó	803	2.1%
Á	29	0.1%

order_customer_id
Real number (ℝ)

Distinct	20652
Distinct (%)	11.4%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	6691.3795

Minimum	1
Maximum	20757
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	1.4 MiB

Quantile statistics

Minimum	1
5-th percentile	649
Q1	3258.5
median	6457
Q3	9779
95-th percentile	12383
Maximum	20757
Range	20756
Interquartile range (IQR)	6520.5

Descriptive statistics

Standard deviation	4162.9181
Coefficient of variation (CV)	0.62213152
Kurtosis	0.014898822
Mean	6691.3795
Median Absolute Deviation (MAD)	3263
Skewness	0.48876825
Sum	1.2079211 × 10⁹
Variance	17329887
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
5654	47	< 0.1%
10591	45	< 0.1%
5004	45	< 0.1%
5715	44	< 0.1%
3708	44	< 0.1%
9371	44	< 0.1%
1443	43	< 0.1%
791	43	< 0.1%
12284	43	< 0.1%
2641	43	< 0.1%
Other values (20642)	180078	99.8%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
1	1	< 0.1%
2	10	< 0.1%
3	18	< 0.1%
4	14	< 0.1%
5	7	< 0.1%
6	15	< 0.1%
7	22	< 0.1%
8	19	< 0.1%
9	14	< 0.1%
10	8	< 0.1%

Value	Count	Frequency (%)
20757	1	< 0.1%
20756	1	< 0.1%
20755	1	< 0.1%
20754	1	< 0.1%
20753	1	< 0.1%
20752	1	< 0.1%
20751	1	< 0.1%
20750	1	< 0.1%
20749	1	< 0.1%
20748	1	< 0.1%

order_date_dateorders
Categorical

HIGH CARDINALITY UNIFORM

Distinct	65752
Distinct (%)	36.4%
Missing	0
Missing (%)	0.0%
Memory size	1.4 MiB

12/14/2016 12:29	5
2/22/2015 14:38	5
2/17/2016 14:08	5
12/31/2016 9:50	5
2/11/2016 16:35	5
Other values (65747)	180494

Length

Max length	16
Median length	15
Mean length	14.498989
Min length	13

Characters and Unicode

Total characters	2617343
Distinct characters	13
Distinct categories	3 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	19850 ?
Unique (%)	11.0%

Sample

1st row	1/31/2018 22:56
2nd row	1/13/2018 12:27
3rd row	1/13/2018 12:06
4th row	1/13/2018 11:45
5th row	1/13/2018 11:24

Common Values

Value	Count	Frequency (%)
12/14/2016 12:29	5	< 0.1%
2/22/2015 14:38	5	< 0.1%
2/17/2016 14:08	5	< 0.1%
12/31/2016 9:50	5	< 0.1%
2/11/2016 16:35	5	< 0.1%
12/8/2015 17:54	5	< 0.1%
1/31/2016 2:46	5	< 0.1%
2/9/2016 14:08	5	< 0.1%
11/21/2016 1:29	5	< 0.1%
2/12/2016 11:10	5	< 0.1%
Other values (65742)	180469	> 99.9%

Length

Histogram of lengths of the category

Value	Count	Frequency (%)
7/2/2017	220	0.1%
10/27/2015	217	0.1%
7/14/2015	213	0.1%
5/22/2017	213	0.1%
3/18/2016	212	0.1%
11/13/2015	212	0.1%
6/30/2015	211	0.1%
9/18/2016	209	0.1%
5/30/2015	209	0.1%
3/30/2015	207	0.1%
Other values (2557)	358915	99.4%

Most occurring characters

Value	Count	Frequency (%)
1	475462	18.2%
2	385354	14.7%
/	361038	13.8%
0	281809	10.8%
	180519	6.9%
:	180519	6.9%
5	159458	6.1%
6	128237	4.9%
7	120120	4.6%
3	113722	4.3%
Other values (3)	231105	8.8%

Most occurring categories

Value	Count	Frequency (%)
Decimal Number	1895267	72.4%
Other Punctuation	541557	20.7%
Space Separator	180519	6.9%

Most frequent character per category

Decimal Number

Value	Count	Frequency (%)
1	475462	25.1%
2	385354	20.3%
0	281809	14.9%
5	159458	8.4%
6	128237	6.8%
7	120120	6.3%
3	113722	6.0%
4	96216	5.1%
8	68825	3.6%
9	66064	3.5%

Other Punctuation

Value	Count	Frequency (%)
/	361038	66.7%
:	180519	33.3%

Space Separator

Value	Count	Frequency (%)
	180519	100.0%

Most occurring scripts

Value	Count	Frequency (%)
Common	2617343	100.0%

Most frequent character per script

Common

Value	Count	Frequency (%)
1	475462	18.2%
2	385354	14.7%
/	361038	13.8%
0	281809	10.8%
	180519	6.9%
:	180519	6.9%
5	159458	6.1%
6	128237	4.9%
7	120120	4.6%
3	113722	4.3%
Other values (3)	231105	8.8%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	2617343	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
1	475462	18.2%
2	385354	14.7%
/	361038	13.8%
0	281809	10.8%
	180519	6.9%
:	180519	6.9%
5	159458	6.1%
6	128237	4.9%
7	120120	4.6%
3	113722	4.3%
Other values (3)	231105	8.8%

order_id
Real number (ℝ)

Distinct	65752
Distinct (%)	36.4%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	36221.895

Minimum	1
Maximum	77204
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	1.4 MiB

Quantile statistics

Minimum	1
5-th percentile	3626.8
Q1	18057
median	36140
Q3	54144
95-th percentile	68596
Maximum	77204
Range	77203
Interquartile range (IQR)	36087

Descriptive statistics

Standard deviation	21045.38
Coefficient of variation (CV)	0.58101266
Kurtosis	-1.1529357
Mean	36221.895
Median Absolute Deviation (MAD)	18042
Skewness	0.032708795
Sum	6.5387402 × 10⁹
Variance	4.42908 × 10⁸
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
48880	5	< 0.1%
3605	5	< 0.1%
28265	5	< 0.1%
50037	5	< 0.1%
27861	5	< 0.1%
23412	5	< 0.1%
27068	5	< 0.1%
27717	5	< 0.1%
47273	5	< 0.1%
27914	5	< 0.1%
Other values (65742)	180469	> 99.9%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
1	1	< 0.1%
2	3	< 0.1%
4	4	< 0.1%
5	5	< 0.1%
7	3	< 0.1%
8	4	< 0.1%
9	3	< 0.1%
10	5	< 0.1%
11	5	< 0.1%
12	5	< 0.1%

Value	Count	Frequency (%)
77204	1	< 0.1%
77203	1	< 0.1%
77202	1	< 0.1%
77201	1	< 0.1%
77200	1	< 0.1%
77199	1	< 0.1%
77198	1	< 0.1%
77197	1	< 0.1%
77196	1	< 0.1%
77195	1	< 0.1%

order_item_cardprod_id
Real number (ℝ)

Distinct	118
Distinct (%)	0.1%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	692.50976

Minimum	19
Maximum	1363
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	1.4 MiB

Quantile statistics

Minimum	19
5-th percentile	191
Q1	403
median	627
Q3	1004
95-th percentile	1073
Maximum	1363
Range	1344
Interquartile range (IQR)	601

Descriptive statistics

Standard deviation	336.44681
Coefficient of variation (CV)	0.48583692
Kurtosis	-1.2674939
Mean	692.50976
Median Absolute Deviation (MAD)	330
Skewness	0.13825461
Sum	1.2501117 × 10⁸
Variance	113196.45
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
365	24515	13.6%
403	22246	12.3%
502	21035	11.7%
1014	19298	10.7%
1004	17325	9.6%
1073	15500	8.6%
957	13729	7.6%
191	12169	6.7%
627	10617	5.9%
1362	838	0.5%
Other values (108)	23247	12.9%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
19	64	< 0.1%
24	74	< 0.1%
35	65	< 0.1%
37	262	0.1%
44	305	0.2%
58	29	< 0.1%
60	10	< 0.1%
61	28	< 0.1%
78	63	< 0.1%
93	280	0.2%

Value	Count	Frequency (%)
1363	650	0.4%
1362	838	0.5%
1361	529	0.3%
1360	357	0.2%
1359	492	0.3%
1358	434	0.2%
1357	208	0.1%
1356	362	0.2%
1355	484	0.3%
1354	483	0.3%

order_item_discount
Real number (ℝ)

HIGH CORRELATION ZEROS

Distinct	1017
Distinct (%)	0.6%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	20.664741

Minimum	0
Maximum	500
Zeros	10028
Zeros (%)	5.6%
Negative	0
Negative (%)	0.0%
Memory size	1.4 MiB

Quantile statistics

Minimum	0
5-th percentile	0
Q1	5.4000001
median	14
Q3	29.99
95-th percentile	62.5
Maximum	500
Range	500
Interquartile range (IQR)	24.59

Descriptive statistics

Standard deviation	21.800901
Coefficient of variation (CV)	1.0549806
Kurtosis	25.231267
Mean	20.664741
Median Absolute Deviation (MAD)	10
Skewness	3.0397955
Sum	3730378.4
Variance	475.27928
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
0	10028	5.6%
6	4589	2.5%
12	4067	2.3%
4	3647	2.0%
8	3626	2.0%
10	3424	1.9%
36	3268	1.8%
30	3230	1.8%
20	3123	1.7%
9	2964	1.6%
Other values (1007)	138553	76.8%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
0	10028	5.6%
0.100000001	3	< 0.1%
0.109999999	15	< 0.1%
0.119999997	29	< 0.1%
0.150000006	7	< 0.1%
0.159999996	7	< 0.1%
0.180000007	3	< 0.1%
0.200000003	16	< 0.1%
0.219999999	6	< 0.1%
0.230000004	44	< 0.1%

Value	Count	Frequency (%)
500	1	< 0.1%
400	1	< 0.1%
375	25	< 0.1%
360	1	< 0.1%
340	1	< 0.1%
320	1	< 0.1%
300	26	< 0.1%
270	25	< 0.1%
260	1	< 0.1%
255	25	< 0.1%

order_item_discount_rate
Real number (ℝ)

HIGH CORRELATION ZEROS

Distinct	18
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	0.10166819

Minimum	0
Maximum	0.25
Zeros	10028
Zeros (%)	5.6%
Negative	0
Negative (%)	0.0%
Memory size	1.4 MiB

Quantile statistics

Minimum	0
5-th percentile	0
Q1	0.039999999
median	0.1
Q3	0.16
95-th percentile	0.25
Maximum	0.25
Range	0.25
Interquartile range (IQR)	0.12

Descriptive statistics

Standard deviation	0.070415215
Coefficient of variation (CV)	0.69259829
Kurtosis	-0.90115686
Mean	0.10166819
Median Absolute Deviation (MAD)	0.059999995
Skewness	0.3409276
Sum	18353.04
Variance	0.0049583025
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=18)

Value	Count	Frequency (%)
0.039999999	10029	5.6%
0.150000006	10029	5.6%
0.25	10029	5.6%
0.200000003	10029	5.6%
0.180000007	10029	5.6%
0.170000002	10029	5.6%
0.050000001	10029	5.6%
0.159999996	10029	5.6%
0.129999995	10029	5.6%
0.119999997	10029	5.6%
Other values (8)	80229	44.4%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
0	10028	5.6%
0.01	10028	5.6%
0.02	10028	5.6%
0.029999999	10029	5.6%
0.039999999	10029	5.6%
0.050000001	10029	5.6%
0.059999999	10029	5.6%
0.07	10029	5.6%
0.090000004	10029	5.6%
0.100000001	10029	5.6%

Value	Count	Frequency (%)
0.25	10029	5.6%
0.200000003	10029	5.6%
0.180000007	10029	5.6%
0.170000002	10029	5.6%
0.159999996	10029	5.6%
0.150000006	10029	5.6%
0.129999995	10029	5.6%
0.119999997	10029	5.6%
0.100000001	10029	5.6%
0.090000004	10029	5.6%

order_item_id
Real number (ℝ)

HIGH CORRELATION UNIFORM UNIQUE

Distinct	180519
Distinct (%)	100.0%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	90260

Minimum	1
Maximum	180519
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	1.4 MiB

Quantile statistics

Minimum	1
5-th percentile	9026.9
Q1	45130.5
median	90260
Q3	135389.5
95-th percentile	171493.1
Maximum	180519
Range	180518
Interquartile range (IQR)	90259

Descriptive statistics

Standard deviation	52111.491
Coefficient of variation (CV)	0.57734867
Kurtosis	-1.2
Mean	90260
Median Absolute Deviation (MAD)	45130
Skewness	8.4554661 × 10^-18
Sum	1.6293645 × 10¹⁰
Variance	2.7156075 × 10⁹
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
180517	1	< 0.1%
42681	1	< 0.1%
28953	1	< 0.1%
39851	1	< 0.1%
173601	1	< 0.1%
46791	1	< 0.1%
166889	1	< 0.1%
31184	1	< 0.1%
29248	1	< 0.1%
161714	1	< 0.1%
Other values (180509)	180509	> 99.9%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
1	1	< 0.1%
2	1	< 0.1%
3	1	< 0.1%
4	1	< 0.1%
5	1	< 0.1%
6	1	< 0.1%
7	1	< 0.1%
8	1	< 0.1%
9	1	< 0.1%
10	1	< 0.1%

Value	Count	Frequency (%)
180519	1	< 0.1%
180518	1	< 0.1%
180517	1	< 0.1%
180516	1	< 0.1%
180515	1	< 0.1%
180514	1	< 0.1%
180513	1	< 0.1%
180512	1	< 0.1%
180511	1	< 0.1%
180510	1	< 0.1%

order_item_product_price
Real number (ℝ)

Distinct	75
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	141.23255

Minimum	9.9899998
Maximum	1999.99
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	1.4 MiB

Quantile statistics

Minimum	9.9899998
5-th percentile	31.99
Q1	50
median	59.990002
Q3	199.99001
95-th percentile	399.98001
Maximum	1999.99
Range	1990
Interquartile range (IQR)	149.99001

Descriptive statistics

Standard deviation	139.73249
Coefficient of variation (CV)	0.98937881
Kurtosis	23.312997
Mean	141.23255
Median Absolute Deviation (MAD)	39.999996
Skewness	3.1910196
Sum	25495159
Variance	19525.169
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
59.99000168	24820	13.7%
129.9900055	22372	12.4%
50	21035	11.7%
49.97999954	19298	10.7%
399.980011	17325	9.6%
199.9900055	15622	8.7%
299.980011	13729	7.6%
99.98999786	12433	6.9%
39.99000168	11201	6.2%
24.98999977	2339	1.3%
Other values (65)	20345	11.3%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
9.989999771	285	0.2%
11.28999996	271	0.2%
11.53999996	529	0.3%
14.98999977	593	0.3%
15.98999977	602	0.3%
17.98999977	298	0.2%
19.98999977	887	0.5%
21.98999977	295	0.2%
22	308	0.2%
24.98999977	2339	1.3%

Value	Count	Frequency (%)
1999.98999	15	< 0.1%
1500	442	0.2%
999.9899902	10	< 0.1%
599.9899902	21	< 0.1%
532.5800171	484	0.3%
461.480011	484	0.3%
452.0400085	592	0.3%
399.9899902	67	< 0.1%
399.980011	17325	9.6%
357.1000061	652	0.4%

order_item_profit_ratio
Real number (ℝ)

Distinct	162
Distinct (%)	0.1%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	0.12064664

Minimum	-2.75
Maximum	0.5
Zeros	1177
Zeros (%)	0.7%
Negative	33784
Negative (%)	18.7%
Memory size	1.4 MiB

Quantile statistics

Minimum	-2.75
5-th percentile	-0.76999998
Q1	0.079999998
median	0.27000001
Q3	0.36000001
95-th percentile	0.47999999
Maximum	0.5
Range	3.25
Interquartile range (IQR)	0.28000002

Descriptive statistics

Standard deviation	0.4667956
Coefficient of variation (CV)	3.8691142
Kurtosis	10.157225
Mean	0.12064664
Median Absolute Deviation (MAD)	0.16999999
Skewness	-2.8935313
Sum	21779.01
Variance	0.21789814
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
0.479999989	9197	5.1%
0.349999994	7997	4.4%
0.25999999	6577	3.6%
0.340000004	6507	3.6%
0.469999999	6378	3.5%
0.360000014	6108	3.4%
0.330000013	5789	3.2%
0.49000001	5688	3.2%
0.289999992	5478	3.0%
0.280000001	5403	3.0%
Other values (152)	115397	63.9%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
-2.75	72	< 0.1%
-2.700000048	252	0.1%
-2.650000095	90	< 0.1%
-2.599999905	181	0.1%
-2.549999952	234	0.1%
-2.5	180	0.1%
-2.450000048	18	< 0.1%
-2.349999905	36	< 0.1%
-2.299999952	18	< 0.1%
-2.25	36	< 0.1%

Value	Count	Frequency (%)
0.5	2529	1.4%
0.49000001	5688	3.2%
0.479999989	9197	5.1%
0.469999999	6378	3.5%
0.460000008	4822	2.7%
0.449999988	3973	2.2%
0.439999998	1390	0.8%
0.430000007	1085	0.6%
0.419999987	1245	0.7%
0.409999996	995	0.6%

order_item_quantity
Categorical

Distinct	5
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	1.4 MiB

1	99134
5	20385
3	20350
4	20335
2	20315

Length

Max length	1
Median length	1
Mean length	1
Min length	1

Characters and Unicode

Total characters	180519
Distinct characters	5
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	1
2nd row	1
3rd row	1
4th row	1
5th row	1

Common Values

Value	Count	Frequency (%)
1	99134	54.9%
5	20385	11.3%
3	20350	11.3%
4	20335	11.3%
2	20315	11.3%

Length

Histogram of lengths of the category

Common Values (Plot)

Value	Count	Frequency (%)
1	99134	54.9%
5	20385	11.3%
3	20350	11.3%
4	20335	11.3%
2	20315	11.3%

Most occurring characters

Value	Count	Frequency (%)
1	99134	54.9%
5	20385	11.3%
3	20350	11.3%
4	20335	11.3%
2	20315	11.3%

Most occurring categories

Value	Count	Frequency (%)
Decimal Number	180519	100.0%

Most frequent character per category

Decimal Number

Value	Count	Frequency (%)
1	99134	54.9%
5	20385	11.3%
3	20350	11.3%
4	20335	11.3%
2	20315	11.3%

Most occurring scripts

Value	Count	Frequency (%)
Common	180519	100.0%

Most frequent character per script

Common

Value	Count	Frequency (%)
1	99134	54.9%
5	20385	11.3%
3	20350	11.3%
4	20335	11.3%
2	20315	11.3%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	180519	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
1	99134	54.9%
5	20385	11.3%
3	20350	11.3%
4	20335	11.3%
2	20315	11.3%

sales
Real number (ℝ)

Distinct	193
Distinct (%)	0.1%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	203.7721

Minimum	9.9899998
Maximum	1999.99
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	1.4 MiB

Quantile statistics

Minimum	9.9899998
5-th percentile	49.98
Q1	119.98
median	199.92
Q3	299.95001
95-th percentile	399.98001
Maximum	1999.99
Range	1990
Interquartile range (IQR)	179.97001

Descriptive statistics

Standard deviation	132.27308
Coefficient of variation (CV)	0.64912262
Kurtosis	23.936561
Mean	203.7721
Median Absolute Deviation (MAD)	79.939995
Skewness	2.884249
Sum	36784735
Variance	17496.167
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
129.9900055	22372	12.4%
399.980011	17325	9.6%
199.9900055	15622	8.7%
299.980011	13729	7.6%
179.9700012	5016	2.8%
299.9500122	4988	2.8%
119.9800034	4968	2.8%
239.9600067	4955	2.7%
59.99000168	4893	2.7%
50	4432	2.5%
Other values (183)	82219	45.5%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
9.989999771	56	< 0.1%
11.28999996	271	0.2%
11.53999996	529	0.3%
14.98999977	124	0.1%
15.98999977	118	0.1%
17.98999977	62	< 0.1%
19.97999954	54	< 0.1%
19.98999977	176	0.1%
21.98999977	51	< 0.1%
22	64	< 0.1%

Value	Count	Frequency (%)
1999.98999	15	< 0.1%
1500	442	0.2%
999.9899902	10	< 0.1%
599.9899902	21	< 0.1%
532.5800171	484	0.3%
500	15	< 0.1%
499.9500122	2510	1.4%
499.75	12	< 0.1%
495	14	< 0.1%
474.9500122	15	< 0.1%

order_item_total
Real number (ℝ)

Distinct	2927
Distinct (%)	1.6%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	183.10761

Minimum	7.4899998
Maximum	1939.99
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	1.4 MiB

Quantile statistics

Minimum	7.4899998
5-th percentile	41.5
Q1	104.38
median	163.99001
Q3	247.39999
95-th percentile	383.98001
Maximum	1939.99
Range	1932.5
Interquartile range (IQR)	143.02

Descriptive statistics

Standard deviation	120.04367
Coefficient of variation (CV)	0.65559084
Kurtosis	23.920362
Mean	183.10761
Median Absolute Deviation (MAD)	67.000008
Skewness	2.8884461
Sum	33054402
Variance	14410.483
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
122.8399963	1264	0.7%
109.1900024	1247	0.7%
124.7900009	1243	0.7%
129.9900055	1243	0.7%
116.9899979	1243	0.7%
123.4899979	1243	0.7%
120.8899994	1243	0.7%
127.3899994	1243	0.7%
97.48999786	1243	0.7%
118.2900009	1243	0.7%
Other values (2917)	168064	93.1%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
7.489999771	3	< 0.1%
7.989999771	3	< 0.1%
8.18999958	3	< 0.1%
8.289999962	3	< 0.1%
8.390000343	3	< 0.1%
8.470000267	15	< 0.1%
8.489999771	3	< 0.1%
8.659999847	29	< 0.1%
8.68999958	3	< 0.1%
8.789999962	3	< 0.1%

Value	Count	Frequency (%)
1939.98999	1	< 0.1%
1919.98999	1	< 0.1%
1899.98999	1	< 0.1%
1889.98999	1	< 0.1%
1859.98999	1	< 0.1%
1819.98999	1	< 0.1%
1799.98999	1	< 0.1%
1759.98999	1	< 0.1%
1739.98999	1	< 0.1%
1699.98999	1	< 0.1%

order_profit_per_order
Real number (ℝ)

Distinct	21998
Distinct (%)	12.2%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	21.974989

Minimum	-4274.98
Maximum	911.79999
Zeros	1177
Zeros (%)	0.7%
Negative	33784
Negative (%)	18.7%
Memory size	1.4 MiB

Quantile statistics

Minimum	-4274.98
5-th percentile	-139.251
Q1	7
median	31.52
Q3	64.800003
95-th percentile	132.28999
Maximum	911.79999
Range	5186.78
Interquartile range (IQR)	57.800003

Descriptive statistics

Standard deviation	104.43353
Coefficient of variation (CV)	4.7523813
Kurtosis	71.377259
Mean	21.974989
Median Absolute Deviation (MAD)	27.88
Skewness	-4.7418341
Sum	3966903
Variance	10906.361
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
0	1177	0.7%
143.9900055	199	0.1%
72	194	0.1%
46.79999924	188	0.1%
24	181	0.1%
18	175	0.1%
63.70000076	172	0.1%
62.40000153	168	0.1%
12	166	0.1%
14.39999962	166	0.1%
Other values (21988)	177733	98.5%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
-4274.97998	1	< 0.1%
-3442.5	1	< 0.1%
-3366	1	< 0.1%
-3000	1	< 0.1%
-2592	1	< 0.1%
-2550	1	< 0.1%
-2351.25	1	< 0.1%
-2328	1	< 0.1%
-2280	1	< 0.1%
-2255.25	1	< 0.1%

Value	Count	Frequency (%)
911.7999878	1	< 0.1%
864	1	< 0.1%
721.5999756	1	< 0.1%
720.2999878	1	< 0.1%
720	2	< 0.1%
712.9500122	1	< 0.1%
708.75	1	< 0.1%
705.5999756	2	< 0.1%
705	1	< 0.1%
698.4000244	2	< 0.1%

order_region
Categorical

Distinct	23
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	1.4 MiB

Central America	28341
Western Europe	27109
South America	14935
Oceania	10148
Northern Europe	9792
Other values (18)	90194

Length

Max length	15
Median length	14
Mean length	12.634304
Min length	6

Characters and Unicode

Total characters	2280732
Distinct characters	26
Distinct categories	3 ?
Distinct scripts	2 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	Southeast Asia
2nd row	South Asia
3rd row	South Asia
4th row	Oceania
5th row	Oceania

Common Values

Value	Count	Frequency (%)
Central America	28341	15.7%
Western Europe	27109	15.0%
South America	14935	8.3%
Oceania	10148	5.6%
Northern Europe	9792	5.4%
Southeast Asia	9539	5.3%
Southern Europe	9431	5.2%
Caribbean	8318	4.6%
West of USA	7993	4.4%
South Asia	7731	4.3%
Other values (13)	47182	26.1%

Length

Histogram of lengths of the category

Value	Count	Frequency (%)
europe	50252	13.9%
america	43276	12.0%
asia	31112	8.6%
central	30571	8.5%
western	27109	7.5%
south	26711	7.4%
of	18953	5.3%
usa	18953	5.3%
west	17698	4.9%
africa	11614	3.2%
Other values (11)	84317	23.4%

Most occurring characters

Value	Count	Frequency (%)
e	267374	11.7%
r	221631	9.7%
	202017	8.9%
a	185888	8.2%
t	170633	7.5%
o	129067	5.7%
n	114572	5.0%
s	105425	4.6%
A	104955	4.6%
i	104468	4.6%
Other values (16)	674702	29.6%

Most occurring categories

Value	Count	Frequency (%)
Lowercase Letter	1693309	74.2%
Uppercase Letter	385406	16.9%
Space Separator	202017	8.9%

Most frequent character per category

Lowercase Letter

Value	Count	Frequency (%)
e	267374	15.8%
r	221631	13.1%
a	185888	11.0%
t	170633	10.1%
o	129067	7.6%
n	114572	6.8%
s	105425	6.2%
i	104468	6.2%
u	97090	5.7%
c	65038	3.8%
Other values (7)	232123	13.7%

Uppercase Letter

Value	Count	Frequency (%)
A	104955	27.2%
S	71678	18.6%
E	70219	18.2%
C	45735	11.9%
W	44807	11.6%
U	24840	6.4%
N	13024	3.4%
O	10148	2.6%

Space Separator

Value	Count	Frequency (%)
	202017	100.0%

Most occurring scripts

Value	Count	Frequency (%)
Latin	2078715	91.1%
Common	202017	8.9%

Most frequent character per script

Latin

Value	Count	Frequency (%)
e	267374	12.9%
r	221631	10.7%
a	185888	8.9%
t	170633	8.2%
o	129067	6.2%
n	114572	5.5%
s	105425	5.1%
A	104955	5.0%
i	104468	5.0%
u	97090	4.7%
Other values (15)	577612	27.8%

Common

Value	Count	Frequency (%)
	202017	100.0%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	2280732	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
e	267374	11.7%
r	221631	9.7%
	202017	8.9%
a	185888	8.2%
t	170633	7.5%
o	129067	5.7%
n	114572	5.0%
s	105425	4.6%
A	104955	4.6%
i	104468	4.6%
Other values (16)	674702	29.6%

order_state
Categorical

Distinct	1089
Distinct (%)	0.6%
Missing	0
Missing (%)	0.0%
Memory size	1.4 MiB

Inglaterra	6722
California	4966
Isla de Francia	4580
Renania del Norte-Westfalia	3303
San Salvador	3055
Other values (1084)	157893

Length

Max length	36
Median length	31
Mean length	10.872617
Min length	3

Characters and Unicode

Total characters	1962714
Distinct characters	83
Distinct categories	8 ?
Distinct scripts	2 ?
Distinct blocks	2 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	16 ?
Unique (%)	< 0.1%

Sample

1st row	Java Occidental
2nd row	Rajastán
3rd row	Rajastán
4th row	Queensland
5th row	Queensland

Common Values

Value	Count	Frequency (%)
Inglaterra	6722	3.7%
California	4966	2.8%
Isla de Francia	4580	2.5%
Renania del Norte-Westfalia	3303	1.8%
San Salvador	3055	1.7%
Nueva York	2753	1.5%
Distrito Federal	2559	1.4%
Texas	2446	1.4%
Nueva Gales del Sur	2370	1.3%
Santo Domingo	2211	1.2%
Other values (1079)	145554	80.6%

Length

Histogram of lengths of the category

Value	Count	Frequency (%)
de	9121	3.5%
del	8417	3.2%
inglaterra	6722	2.5%
california	5580	2.1%
nueva	5473	2.1%
isla	4667	1.8%
francia	4580	1.7%
san	3965	1.5%
sur	3354	1.3%
norte-westfalia	3303	1.3%
Other values (1171)	208627	79.1%

Most occurring characters

Value	Count	Frequency (%)
a	310562	15.8%
n	142494	7.3%
i	131317	6.7%
e	131085	6.7%
r	117395	6.0%
o	114621	5.8%
l	103549	5.3%
	83290	4.2%
t	80118	4.1%
s	75596	3.9%
Other values (73)	672687	34.3%

Most occurring categories

Value	Count	Frequency (%)
Lowercase Letter	1584761	80.7%
Uppercase Letter	268229	13.7%
Space Separator	83290	4.2%
Dash Punctuation	24466	1.2%
Open Punctuation	664	< 0.1%
Close Punctuation	664	< 0.1%
Other Punctuation	627	< 0.1%
Control	13	< 0.1%

Most frequent character per category

Lowercase Letter

Value	Count	Frequency (%)
a	310562	19.6%
n	142494	9.0%
i	131317	8.3%
e	131085	8.3%
r	117395	7.4%
o	114621	7.2%
l	103549	6.5%
t	80118	5.1%
s	75596	4.8%
u	62262	3.9%
Other values (35)	315762	19.9%

Uppercase Letter

Value	Count	Frequency (%)
C	30372	11.3%
S	27262	10.2%
A	20489	7.6%
P	18540	6.9%
M	16660	6.2%
N	16027	6.0%
I	14188	5.3%
B	12615	4.7%
G	12427	4.6%
L	11348	4.2%
Other values (20)	88301	32.9%

Other Punctuation

Value	Count	Frequency (%)
?	503	80.2%
'	124	19.8%

Control

Value	Count	Frequency (%)
	8	61.5%
	5	38.5%

Space Separator

Value	Count	Frequency (%)
	83290	100.0%

Dash Punctuation

Value	Count	Frequency (%)
-	24466	100.0%

Open Punctuation

Value	Count	Frequency (%)
(	664	100.0%

Close Punctuation

Value	Count	Frequency (%)
)	664	100.0%

Most occurring scripts

Value	Count	Frequency (%)
Latin	1852990	94.4%
Common	109724	5.6%

Most frequent character per script

Latin

Value	Count	Frequency (%)
a	310562	16.8%
n	142494	7.7%
i	131317	7.1%
e	131085	7.1%
r	117395	6.3%
o	114621	6.2%
l	103549	5.6%
t	80118	4.3%
s	75596	4.1%
u	62262	3.4%
Other values (65)	583991	31.5%

Common

Value	Count	Frequency (%)
	83290	75.9%
-	24466	22.3%
(	664	0.6%
)	664	0.6%
?	503	0.5%
'	124	0.1%
	8	< 0.1%
	5	< 0.1%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	1925211	98.1%
None	37503	1.9%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
a	310562	16.1%
n	142494	7.4%
i	131317	6.8%
e	131085	6.8%
r	117395	6.1%
o	114621	6.0%
l	103549	5.4%
	83290	4.3%
t	80118	4.2%
s	75596	3.9%
Other values (48)	635184	33.0%

None

Value	Count	Frequency (%)
í	11965	31.9%
á	10023	26.7%
ó	4698	12.5%
é	3332	8.9%
ñ	3173	8.5%
ã	2031	5.4%
ú	918	2.4%
ü	380	1.0%
à	171	0.5%
ô	168	0.4%
Other values (15)	644	1.7%

order_status
Categorical

Distinct	9
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	1.4 MiB

COMPLETE	59491
PENDING_PAYMENT	39832
PROCESSING	21902
PENDING	20227
CLOSED	19616
Other values (4)	19451

Length

Max length	15
Median length	14
Mean length	9.6239676
Min length	6

Characters and Unicode

Total characters	1737309
Distinct characters	21
Distinct categories	2 ?
Distinct scripts	2 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	COMPLETE
2nd row	PENDING
3rd row	CLOSED
4th row	COMPLETE
5th row	PENDING_PAYMENT

Common Values

Value	Count	Frequency (%)
COMPLETE	59491	33.0%
PENDING_PAYMENT	39832	22.1%
PROCESSING	21902	12.1%
PENDING	20227	11.2%
CLOSED	19616	10.9%
ON_HOLD	9804	5.4%
SUSPECTED_FRAUD	4062	2.3%
CANCELED	3692	2.0%
PAYMENT_REVIEW	1893	1.0%

Length

Histogram of lengths of the category

Common Values (Plot)

Value	Count	Frequency (%)
complete	59491	33.0%
pending_payment	39832	22.1%
processing	21902	12.1%
pending	20227	11.2%
closed	19616	10.9%
on_hold	9804	5.4%
suspected_fraud	4062	2.3%
canceled	3692	2.0%
payment_review	1893	1.0%

Most occurring characters

Value	Count	Frequency (%)
E	281578	16.2%
N	197241	11.4%
P	187239	10.8%
O	120617	6.9%
C	112455	6.5%
T	105278	6.1%
D	101295	5.8%
M	101216	5.8%
L	92603	5.3%
I	83854	4.8%
Other values (11)	353933	20.4%

Most occurring categories

Value	Count	Frequency (%)
Uppercase Letter	1681718	96.8%
Connector Punctuation	55591	3.2%

Most frequent character per category

Uppercase Letter

Value	Count	Frequency (%)
E	281578	16.7%
N	197241	11.7%
P	187239	11.1%
O	120617	7.2%
C	112455	6.7%
T	105278	6.3%
D	101295	6.0%
M	101216	6.0%
L	92603	5.5%
I	83854	5.0%
Other values (10)	298342	17.7%

Connector Punctuation

Value	Count	Frequency (%)
_	55591	100.0%

Most occurring scripts

Value	Count	Frequency (%)
Latin	1681718	96.8%
Common	55591	3.2%

Most frequent character per script

Latin

Value	Count	Frequency (%)
E	281578	16.7%
N	197241	11.7%
P	187239	11.1%
O	120617	7.2%
C	112455	6.7%
T	105278	6.3%
D	101295	6.0%
M	101216	6.0%
L	92603	5.5%
I	83854	5.0%
Other values (10)	298342	17.7%

Common

Value	Count	Frequency (%)
_	55591	100.0%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	1737309	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
E	281578	16.2%
N	197241	11.4%
P	187239	10.8%
O	120617	6.9%
C	112455	6.5%
T	105278	6.1%
D	101295	5.8%
M	101216	5.8%
L	92603	5.3%
I	83854	4.8%
Other values (11)	353933	20.4%

order_zipcode
Real number (ℝ)

HIGH CORRELATION MISSING

Distinct	609
Distinct (%)	2.5%
Missing	155679
Missing (%)	86.2%
Infinite	0
Infinite (%)	0.0%
Mean	55426.132

Minimum	1040
Maximum	99301
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	1.4 MiB

Quantile statistics

Minimum	1040
5-th percentile	10009
Q1	23464
median	59405
Q3	90008
95-th percentile	98026
Maximum	99301
Range	98261
Interquartile range (IQR)	66544

Descriptive statistics

Standard deviation	31919.279
Coefficient of variation (CV)	0.57588862
Kurtosis	-1.4817345
Mean	55426.132
Median Absolute Deviation (MAD)	30631
Skewness	-0.1403114
Sum	1.3767851 × 10⁹
Variance	1.0188404 × 10⁹
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
10035	648	0.4%
10009	550	0.3%
10024	541	0.3%
94122	526	0.3%
10011	463	0.3%
94110	407	0.2%
98105	406	0.2%
19140	386	0.2%
90049	368	0.2%
98103	366	0.2%
Other values (599)	20179	11.2%
(Missing)	155679	86.2%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
1040	3	< 0.1%
1453	17	< 0.1%
1752	6	< 0.1%
1810	13	< 0.1%
1841	88	< 0.1%
1852	38	< 0.1%
1915	2	< 0.1%
2038	39	< 0.1%
2138	14	< 0.1%
2148	3	< 0.1%

Value	Count	Frequency (%)
99301	10	< 0.1%
99207	22	< 0.1%
98661	12	< 0.1%
98632	10	< 0.1%
98502	9	< 0.1%
98270	3	< 0.1%
98226	3	< 0.1%
98208	5	< 0.1%
98198	17	< 0.1%
98115	294	0.2%

product_card_id
Real number (ℝ)

Distinct	118
Distinct (%)	0.1%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	692.50976

Minimum	19
Maximum	1363
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	1.4 MiB

Quantile statistics

Minimum	19
5-th percentile	191
Q1	403
median	627
Q3	1004
95-th percentile	1073
Maximum	1363
Range	1344
Interquartile range (IQR)	601

Descriptive statistics

Standard deviation	336.44681
Coefficient of variation (CV)	0.48583692
Kurtosis	-1.2674939
Mean	692.50976
Median Absolute Deviation (MAD)	330
Skewness	0.13825461
Sum	1.2501117 × 10⁸
Variance	113196.45
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
365	24515	13.6%
403	22246	12.3%
502	21035	11.7%
1014	19298	10.7%
1004	17325	9.6%
1073	15500	8.6%
957	13729	7.6%
191	12169	6.7%
627	10617	5.9%
1362	838	0.5%
Other values (108)	23247	12.9%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
19	64	< 0.1%
24	74	< 0.1%
35	65	< 0.1%
37	262	0.1%
44	305	0.2%
58	29	< 0.1%
60	10	< 0.1%
61	28	< 0.1%
78	63	< 0.1%
93	280	0.2%

Value	Count	Frequency (%)
1363	650	0.4%
1362	838	0.5%
1361	529	0.3%
1360	357	0.2%
1359	492	0.3%
1358	434	0.2%
1357	208	0.1%
1356	362	0.2%
1355	484	0.3%
1354	483	0.3%

product_category_id
Real number (ℝ)

Distinct	51
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	31.851451

Minimum	2
Maximum	76
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	1.4 MiB

Quantile statistics

Minimum	2
5-th percentile	9
Q1	18
median	29
Q3	45
95-th percentile	48
Maximum	76
Range	74
Interquartile range (IQR)	27

Descriptive statistics

Standard deviation	15.640064
Coefficient of variation (CV)	0.49103145
Kurtosis	-0.60326101
Mean	31.851451
Median Absolute Deviation (MAD)	14
Skewness	0.3616248
Sum	5749792
Variance	244.6116
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
17	24551	13.6%
18	22246	12.3%
24	21035	11.7%
46	19298	10.7%
45	17325	9.6%
48	15540	8.6%
43	13729	7.6%
9	12487	6.9%
29	10984	6.1%
37	2029	1.1%
Other values (41)	21295	11.8%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
2	138	0.1%
3	632	0.4%
4	67	< 0.1%
5	343	0.2%
6	328	0.2%
7	614	0.3%
9	12487	6.9%
10	111	0.1%
11	309	0.2%
12	423	0.2%

Value	Count	Frequency (%)
76	650	0.4%
75	838	0.5%
74	529	0.3%
73	357	0.2%
72	492	0.3%
71	434	0.2%
70	208	0.1%
69	362	0.2%
68	484	0.3%
67	483	0.3%

product_description
Unsupported

MISSING REJECTED UNSUPPORTED

Missing	180519
Missing (%)	100.0%
Memory size	1.4 MiB

product_image
Categorical

Distinct	118
Distinct (%)	0.1%
Missing	0
Missing (%)	0.0%
Memory size	1.4 MiB

http://images.acmesports.sports/Perfect+Fitness+Perfect+Rip+Deck	24515
http://images.acmesports.sports/Nike+Men%27s+CJ+Elite+2+TD+Football+Cleat	22246
http://images.acmesports.sports/Nike+Men%27s+Dri-FIT+Victory+Golf+Polo	21035
http://images.acmesports.sports/O%27Brien+Men%27s+Neoprene+Life+Vest	19298
http://images.acmesports.sports/Field+%26+Stream+Sportsman+16+Gun+Fire+Safe	17325
Other values (113)	76100

Length

Max length	94
Median length	90
Mean length	69.947014
Min length	36

Characters and Unicode

Total characters	12626765
Distinct characters	66
Distinct categories	7 ?
Distinct scripts	2 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	http://images.acmesports.sports/Smart+watch
2nd row	http://images.acmesports.sports/Smart+watch
3rd row	http://images.acmesports.sports/Smart+watch
4th row	http://images.acmesports.sports/Smart+watch
5th row	http://images.acmesports.sports/Smart+watch

Common Values

Value	Count	Frequency (%)
http://images.acmesports.sports/Perfect+Fitness+Perfect+Rip+Deck	24515	13.6%
http://images.acmesports.sports/Nike+Men%27s+CJ+Elite+2+TD+Football+Cleat	22246	12.3%
http://images.acmesports.sports/Nike+Men%27s+Dri-FIT+Victory+Golf+Polo	21035	11.7%
http://images.acmesports.sports/O%27Brien+Men%27s+Neoprene+Life+Vest	19298	10.7%
http://images.acmesports.sports/Field+%26+Stream+Sportsman+16+Gun+Fire+Safe	17325	9.6%
http://images.acmesports.sports/Pelican+Sunstream+100+Kayak	15500	8.6%
http://images.acmesports.sports/Diamondback+Women%27s+Serene+Classic+Comfort+Bike+2014	13729	7.6%
http://images.acmesports.sports/Nike+Men%27s+Free+5.0%2B+Running+Shoe	12169	6.7%
http://images.acmesports.sports/Under+Armour+Girls%27+Toddler+Spine+Surge+Running+Shoe	10617	5.9%
http://images.acmesports.sports/Fighting+video+games	838	0.5%
Other values (108)	23247	12.9%

Length

Histogram of lengths of the category

Value	Count	Frequency (%)
http://images.acmesports.sports/perfect+fitness+perfect+rip+deck	24515	13.6%
http://images.acmesports.sports/nike+men%27s+cj+elite+2+td+football+cleat	22246	12.3%
http://images.acmesports.sports/nike+men%27s+dri-fit+victory+golf+polo	21035	11.7%
http://images.acmesports.sports/o%27brien+men%27s+neoprene+life+vest	19298	10.7%
http://images.acmesports.sports/field+%26+stream+sportsman+16+gun+fire+safe	17325	9.6%
http://images.acmesports.sports/pelican+sunstream+100+kayak	15500	8.6%
http://images.acmesports.sports/diamondback+women%27s+serene+classic+comfort+bike+2014	13729	7.6%
http://images.acmesports.sports/nike+men%27s+free+5.0%2b+running+shoe	12169	6.7%
http://images.acmesports.sports/under+armour+girls%27+toddler+spine+surge+running+shoe	10617	5.9%
http://images.acmesports.sports/fighting+video+games	838	0.5%
Other values (108)	23247	12.9%

Most occurring characters

Value	Count	Frequency (%)
s	1166577	9.2%
e	1121625	8.9%
t	997512	7.9%
+	913711	7.2%
r	703683	5.6%
o	666883	5.3%
p	620629	4.9%
a	593978	4.7%
i	559394	4.4%
/	541557	4.3%
Other values (56)	4741216	37.5%

Most occurring categories

Value	Count	Frequency (%)
Lowercase Letter	8804395	69.7%
Other Punctuation	1255258	9.9%
Uppercase Letter	1137901	9.0%
Math Symbol	913711	7.2%
Decimal Number	491276	3.9%
Dash Punctuation	23338	0.2%
Space Separator	886	< 0.1%

Most frequent character per category

Uppercase Letter

Value	Count	Frequency (%)
S	137110	12.0%
F	120346	10.6%
P	93021	8.2%
D	85981	7.6%
M	81289	7.1%
N	79408	7.0%
C	78303	6.9%
T	64674	5.7%
G	63324	5.6%
B	52566	4.6%
Other values (15)	281879	24.8%

Lowercase Letter

Value	Count	Frequency (%)
s	1166577	13.2%
e	1121625	12.7%
t	997512	11.3%
r	703683	8.0%
o	666883	7.6%
p	620629	7.0%
a	593978	6.7%
i	559394	6.4%
m	481927	5.5%
n	361861	4.1%
Other values (14)	1530326	17.4%

Decimal Number

Value	Count	Frequency (%)
2	193261	39.3%
7	126306	25.7%
0	58520	11.9%
1	48714	9.9%
6	35961	7.3%
4	14542	3.0%
5	12729	2.6%
3	643	0.1%
8	555	0.1%
9	45	< 0.1%

Other Punctuation

Value	Count	Frequency (%)
/	541557	43.1%
.	376918	30.0%
:	180519	14.4%
%	156264	12.4%

Math Symbol

Value	Count	Frequency (%)
+	913711	100.0%

Dash Punctuation

Value	Count	Frequency (%)
-	23338	100.0%

Space Separator

Value	Count	Frequency (%)
	886	100.0%

Most occurring scripts

Value	Count	Frequency (%)
Latin	9942296	78.7%
Common	2684469	21.3%

Most frequent character per script

Latin

Value	Count	Frequency (%)
s	1166577	11.7%
e	1121625	11.3%
t	997512	10.0%
r	703683	7.1%
o	666883	6.7%
p	620629	6.2%
a	593978	6.0%
i	559394	5.6%
m	481927	4.8%
n	361861	3.6%
Other values (39)	2668227	26.8%

Common

Value	Count	Frequency (%)
+	913711	34.0%
/	541557	20.2%
.	376918	14.0%
2	193261	7.2%
:	180519	6.7%
%	156264	5.8%
7	126306	4.7%
0	58520	2.2%
1	48714	1.8%
6	35961	1.3%
Other values (7)	52738	2.0%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	12626765	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
s	1166577	9.2%
e	1121625	8.9%
t	997512	7.9%
+	913711	7.2%
r	703683	5.6%
o	666883	5.3%
p	620629	4.9%
a	593978	4.7%
i	559394	4.4%
/	541557	4.3%
Other values (56)	4741216	37.5%

product_name
Categorical

Distinct	118
Distinct (%)	0.1%
Missing	0
Missing (%)	0.0%
Memory size	1.4 MiB

Perfect Fitness Perfect Rip Deck	24515
Nike Men's CJ Elite 2 TD Football Cleat	22246
Nike Men's Dri-FIT Victory Golf Polo	21035
O'Brien Men's Neoprene Life Vest	19298
Field & Stream Sportsman 16 Gun Fire Safe	17325
Other values (113)	76100

Length

Max length	45
Median length	43
Mean length	35.120004
Min length	5

Characters and Unicode

Total characters	6339828
Distinct characters	66
Distinct categories	7 ?
Distinct scripts	2 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	Smart watch
2nd row	Smart watch
3rd row	Smart watch
4th row	Smart watch
5th row	Smart watch

Common Values

Value	Count	Frequency (%)
Perfect Fitness Perfect Rip Deck	24515	13.6%
Nike Men's CJ Elite 2 TD Football Cleat	22246	12.3%
Nike Men's Dri-FIT Victory Golf Polo	21035	11.7%
O'Brien Men's Neoprene Life Vest	19298	10.7%
Field & Stream Sportsman 16 Gun Fire Safe	17325	9.6%
Pelican Sunstream 100 Kayak	15500	8.6%
Diamondback Women's Serene Classic Comfort Bi	13729	7.6%
Nike Men's Free 5.0+ Running Shoe	12169	6.7%
Under Armour Girls' Toddler Spine Surge Runni	10617	5.9%
Fighting video games	838	0.5%
Other values (108)	23247	12.9%

Length

Histogram of lengths of the category

Value	Count	Frequency (%)
men's	77602	7.3%
nike	57309	5.4%
perfect	49030	4.6%
golf	26281	2.5%
rip	24515	2.3%
deck	24515	2.3%
fitness	24515	2.3%
cleat	22813	2.1%
2	22574	2.1%
elite	22309	2.1%
Other values (351)	715106	67.0%

Most occurring characters

Value	Count	Frequency (%)
	887824	14.0%
e	733504	11.6%
i	378177	6.0%
n	350567	5.5%
r	340664	5.4%
o	293733	4.6%
t	274503	4.3%
s	263028	4.1%
l	230952	3.6%
a	230847	3.6%
Other values (56)	2356029	37.2%

Most occurring categories

Value	Count	Frequency (%)
Lowercase Letter	4011603	63.3%
Uppercase Letter	1110988	17.5%
Space Separator	887824	14.0%
Other Punctuation	157902	2.5%
Decimal Number	136270	2.1%
Dash Punctuation	23040	0.4%
Math Symbol	12201	0.2%

Most frequent character per category

Uppercase Letter

Value	Count	Frequency (%)
S	126137	11.4%
F	119900	10.8%
P	92713	8.3%
D	85981	7.7%
M	81289	7.3%
N	79408	7.1%
C	77993	7.0%
T	64000	5.8%
G	62759	5.6%
R	50142	4.5%
Other values (15)	270666	24.4%

Lowercase Letter

Value	Count	Frequency (%)
e	733504	18.3%
i	378177	9.4%
n	350567	8.7%
r	340664	8.5%
o	293733	7.3%
t	274503	6.8%
s	263028	6.6%
l	230952	5.8%
a	230847	5.8%
c	150579	3.8%
Other values (14)	765049	19.1%

Decimal Number

Value	Count	Frequency (%)
0	44762	32.8%
1	34956	25.7%
2	23239	17.1%
6	18574	13.6%
5	12729	9.3%
4	756	0.6%
3	643	0.5%
8	555	0.4%
9	45	< 0.1%
7	11	< 0.1%

Other Punctuation

Value	Count	Frequency (%)
'	127155	80.5%
&	17387	11.0%
.	12979	8.2%
/	381	0.2%

Space Separator

Value	Count	Frequency (%)
	887824	100.0%

Dash Punctuation

Value	Count	Frequency (%)
-	23040	100.0%

Math Symbol

Value	Count	Frequency (%)
+	12201	100.0%

Most occurring scripts

Value	Count	Frequency (%)
Latin	5122591	80.8%
Common	1217237	19.2%

Most frequent character per script

Latin

Value	Count	Frequency (%)
e	733504	14.3%
i	378177	7.4%
n	350567	6.8%
r	340664	6.7%
o	293733	5.7%
t	274503	5.4%
s	263028	5.1%
l	230952	4.5%
a	230847	4.5%
c	150579	2.9%
Other values (39)	1876037	36.6%

Common

Value	Count	Frequency (%)
	887824	72.9%
'	127155	10.4%
0	44762	3.7%
1	34956	2.9%
2	23239	1.9%
-	23040	1.9%
6	18574	1.5%
&	17387	1.4%
.	12979	1.1%
5	12729	1.0%
Other values (7)	14592	1.2%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	6339828	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
	887824	14.0%
e	733504	11.6%
i	378177	6.0%
n	350567	5.5%
r	340664	5.4%
o	293733	4.6%
t	274503	4.3%
s	263028	4.1%
l	230952	3.6%
a	230847	3.6%
Other values (56)	2356029	37.2%

product_price
Real number (ℝ)

Distinct	75
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	141.23255

Minimum	9.9899998
Maximum	1999.99
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	1.4 MiB

Quantile statistics

Minimum	9.9899998
5-th percentile	31.99
Q1	50
median	59.990002
Q3	199.99001
95-th percentile	399.98001
Maximum	1999.99
Range	1990
Interquartile range (IQR)	149.99001

Descriptive statistics

Standard deviation	139.73249
Coefficient of variation (CV)	0.98937881
Kurtosis	23.312997
Mean	141.23255
Median Absolute Deviation (MAD)	39.999996
Skewness	3.1910196
Sum	25495159
Variance	19525.169
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
59.99000168	24820	13.7%
129.9900055	22372	12.4%
50	21035	11.7%
49.97999954	19298	10.7%
399.980011	17325	9.6%
199.9900055	15622	8.7%
299.980011	13729	7.6%
99.98999786	12433	6.9%
39.99000168	11201	6.2%
24.98999977	2339	1.3%
Other values (65)	20345	11.3%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
9.989999771	285	0.2%
11.28999996	271	0.2%
11.53999996	529	0.3%
14.98999977	593	0.3%
15.98999977	602	0.3%
17.98999977	298	0.2%
19.98999977	887	0.5%
21.98999977	295	0.2%
22	308	0.2%
24.98999977	2339	1.3%

Value	Count	Frequency (%)
1999.98999	15	< 0.1%
1500	442	0.2%
999.9899902	10	< 0.1%
599.9899902	21	< 0.1%
532.5800171	484	0.3%
461.480011	484	0.3%
452.0400085	592	0.3%
399.9899902	67	< 0.1%
399.980011	17325	9.6%
357.1000061	652	0.4%

product_status
Categorical

Distinct	1
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	1.4 MiB

0	180519

Length

Max length	1
Median length	1
Mean length	1
Min length	1

Characters and Unicode

Total characters	180519
Distinct characters	1
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	0
2nd row	0
3rd row	0
4th row	0
5th row	0

Common Values

Value	Count	Frequency (%)
0	180519	100.0%

Length

Histogram of lengths of the category

Common Values (Plot)

Value	Count	Frequency (%)
0	180519	100.0%

Most occurring characters

Value	Count	Frequency (%)
0	180519	100.0%

Most occurring categories

Value	Count	Frequency (%)
Decimal Number	180519	100.0%

Most frequent character per category

Decimal Number

Value	Count	Frequency (%)
0	180519	100.0%

Most occurring scripts

Value	Count	Frequency (%)
Common	180519	100.0%

Most frequent character per script

Common

Value	Count	Frequency (%)
0	180519	100.0%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	180519	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
0	180519	100.0%

shipping_date_dateorders
Categorical

HIGH CARDINALITY UNIFORM

Distinct	63701
Distinct (%)	35.3%
Missing	0
Missing (%)	0.0%
Memory size	1.4 MiB

1/5/2016 5:58	10
7/16/2015 10:14	10
4/17/2015 22:16	10
5/27/2015 6:48	10
5/9/2015 18:02	10
Other values (63696)	180469

Length

Max length	16
Median length	15
Mean length	14.501942
Min length	13

Characters and Unicode

Total characters	2617876
Distinct characters	13
Distinct categories	3 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	18557 ?
Unique (%)	10.3%

Sample

1st row	2/3/2018 22:56
2nd row	1/18/2018 12:27
3rd row	1/17/2018 12:06
4th row	1/16/2018 11:45
5th row	1/15/2018 11:24

Common Values

Value	Count	Frequency (%)
1/5/2016 5:58	10	< 0.1%
7/16/2015 10:14	10	< 0.1%
4/17/2015 22:16	10	< 0.1%
5/27/2015 6:48	10	< 0.1%
5/9/2015 18:02	10	< 0.1%
3/13/2016 5:10	10	< 0.1%
12/16/2015 2:50	10	< 0.1%
6/5/2017 12:25	10	< 0.1%
5/8/2015 2:06	10	< 0.1%
3/31/2017 19:52	10	< 0.1%
Other values (63691)	180419	99.9%

Length

Histogram of lengths of the category

Value	Count	Frequency (%)
9/27/2017	266	0.1%
5/4/2017	244	0.1%
7/9/2017	242	0.1%
7/16/2016	240	0.1%
8/22/2016	239	0.1%
1/15/2017	239	0.1%
2/21/2016	237	0.1%
9/20/2016	232	0.1%
11/4/2015	231	0.1%
5/12/2017	228	0.1%
Other values (2561)	358640	99.3%

Most occurring characters

Value	Count	Frequency (%)
1	475279	18.2%
2	385619	14.7%
/	361038	13.8%
0	282104	10.8%
	180519	6.9%
:	180519	6.9%
5	159085	6.1%
6	128246	4.9%
7	120339	4.6%
3	113285	4.3%
Other values (3)	231843	8.9%

Most occurring categories

Value	Count	Frequency (%)
Decimal Number	1895800	72.4%
Other Punctuation	541557	20.7%
Space Separator	180519	6.9%

Most frequent character per category

Decimal Number

Value	Count	Frequency (%)
1	475279	25.1%
2	385619	20.3%
0	282104	14.9%
5	159085	8.4%
6	128246	6.8%
7	120339	6.3%
3	113285	6.0%
4	96927	5.1%
8	68656	3.6%
9	66260	3.5%

Other Punctuation

Value	Count	Frequency (%)
/	361038	66.7%
:	180519	33.3%

Space Separator

Value	Count	Frequency (%)
	180519	100.0%

Most occurring scripts

Value	Count	Frequency (%)
Common	2617876	100.0%

Most frequent character per script

Common

Value	Count	Frequency (%)
1	475279	18.2%
2	385619	14.7%
/	361038	13.8%
0	282104	10.8%
	180519	6.9%
:	180519	6.9%
5	159085	6.1%
6	128246	4.9%
7	120339	4.6%
3	113285	4.3%
Other values (3)	231843	8.9%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	2617876	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
1	475279	18.2%
2	385619	14.7%
/	361038	13.8%
0	282104	10.8%
	180519	6.9%
:	180519	6.9%
5	159085	6.1%
6	128246	4.9%
7	120339	4.6%
3	113285	4.3%
Other values (3)	231843	8.9%

shipping_mode
Categorical

Distinct	4
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	1.4 MiB

Standard Class	107752
Second Class	35216
First Class	27814
Same Day	9737

Length

Max length	14
Median length	14
Mean length	12.823969
Min length	8

Characters and Unicode

Total characters	2314970
Distinct characters	18
Distinct categories	3 ?
Distinct scripts	2 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	Standard Class
2nd row	Standard Class
3rd row	Standard Class
4th row	Standard Class
5th row	Standard Class

Common Values

Value	Count	Frequency (%)
Standard Class	107752	59.7%
Second Class	35216	19.5%
First Class	27814	15.4%
Same Day	9737	5.4%

Length

Histogram of lengths of the category

Common Values (Plot)

Value	Count	Frequency (%)
class	170782	47.3%
standard	107752	29.8%
second	35216	9.8%
first	27814	7.7%
same	9737	2.7%
day	9737	2.7%

Most occurring characters

Value	Count	Frequency (%)
a	405760	17.5%
s	369378	16.0%
d	250720	10.8%
	180519	7.8%
l	170782	7.4%
C	170782	7.4%
S	152705	6.6%
n	142968	6.2%
r	135566	5.9%
t	135566	5.9%
Other values (8)	200224	8.6%

Most occurring categories

Value	Count	Frequency (%)
Lowercase Letter	1773413	76.6%
Uppercase Letter	361038	15.6%
Space Separator	180519	7.8%

Most frequent character per category

Lowercase Letter

Value	Count	Frequency (%)
a	405760	22.9%
s	369378	20.8%
d	250720	14.1%
l	170782	9.6%
n	142968	8.1%
r	135566	7.6%
t	135566	7.6%
e	44953	2.5%
c	35216	2.0%
o	35216	2.0%
Other values (3)	47288	2.7%

Uppercase Letter

Value	Count	Frequency (%)
C	170782	47.3%
S	152705	42.3%
F	27814	7.7%
D	9737	2.7%

Space Separator

Value	Count	Frequency (%)
	180519	100.0%

Most occurring scripts

Value	Count	Frequency (%)
Latin	2134451	92.2%
Common	180519	7.8%

Most frequent character per script

Latin

Value	Count	Frequency (%)
a	405760	19.0%
s	369378	17.3%
d	250720	11.7%
l	170782	8.0%
C	170782	8.0%
S	152705	7.2%
n	142968	6.7%
r	135566	6.4%
t	135566	6.4%
e	44953	2.1%
Other values (7)	155271	7.3%

Common

Value	Count	Frequency (%)
	180519	100.0%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	2314970	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
a	405760	17.5%
s	369378	16.0%
d	250720	10.8%
	180519	7.8%
l	170782	7.4%
C	170782	7.4%
S	152705	6.6%
n	142968	6.2%
r	135566	5.9%
t	135566	5.9%
Other values (8)	200224	8.6%

Auto

Heatmap
Table

	days_for_shipping_real	benefit_per_order	sales_per_customer	category_id	customer_id	customer_zipcode	department_id	latitude	longitude	order_customer_id	order_id	order_item_cardprod_id	order_item_discount	order_item_discount_rate	order_item_id	order_item_product_price	order_item_profit_ratio	sales	order_item_total	order_profit_per_order	order_zipcode	product_card_id	product_category_id	product_price	type	days_for_shipment_scheduled	delivery_status	late_delivery_risk	category_name	customer_country	customer_segment	customer_state	department_name	market	order_item_quantity	order_region	order_status	shipping_mode
days_for_shipping_real	1.000	-0.003	-0.000	-0.002	0.004	-0.002	-0.002	-0.003	0.001	0.004	-0.002	-0.002	0.001	0.001	-0.002	-0.000	-0.003	-0.000	-0.000	-0.003	-0.002	-0.002	-0.002	-0.000	0.010	0.681	0.561	0.631	0.006	0.011	0.009	0.027	0.006	0.008	0.000	0.022	0.008	0.681
benefit_per_order	-0.003	1.000	0.441	0.061	0.003	0.002	0.085	0.002	-0.003	0.003	0.017	0.060	0.196	-0.054	0.017	0.287	0.808	0.436	0.441	1.000	-0.007	0.060	0.061	0.287	0.003	0.002	0.000	0.000	0.232	0.000	0.000	0.011	0.127	0.021	0.034	0.014	0.000	0.002
sales_per_customer	-0.000	0.441	1.000	0.162	0.013	-0.001	0.224	0.000	0.003	0.013	0.041	0.160	0.420	-0.133	0.041	0.639	-0.000	0.986	1.000	0.441	-0.003	0.160	0.162	0.639	0.005	0.004	0.005	0.000	0.480	0.000	0.006	0.000	0.241	0.036	0.212	0.026	0.006	0.004
category_id	-0.002	0.061	0.162	1.000	0.133	0.002	0.908	0.002	0.015	0.133	0.135	0.998	0.073	0.000	0.135	0.195	-0.002	0.178	0.162	0.061	-0.007	0.998	1.000	0.195	0.001	0.009	0.000	0.000	0.973	0.000	0.008	0.008	0.683	0.158	0.232	0.118	0.001	0.009
customer_id	0.004	0.003	0.013	0.133	1.000	-0.000	0.061	0.006	-0.011	1.000	0.133	0.133	0.003	0.002	0.133	0.039	-0.000	0.014	0.013	0.003	-0.006	0.133	0.133	0.039	0.005	0.009	0.006	0.004	0.512	0.015	0.031	0.050	0.336	0.179	0.099	0.134	0.008	0.009
customer_zipcode	-0.002	0.002	-0.001	0.002	-0.000	1.000	0.003	0.639	-0.946	-0.000	-0.002	0.002	-0.001	-0.001	-0.002	0.002	0.005	-0.001	-0.001	0.002	0.011	0.002	0.002	0.002	0.010	0.013	0.012	0.012	0.002	0.902	0.028	0.974	0.002	0.013	0.000	0.018	0.010	0.013
department_id	-0.002	0.085	0.224	0.908	0.061	0.003	1.000	0.003	0.004	0.061	0.063	0.905	0.102	0.000	0.063	0.202	-0.003	0.241	0.224	0.085	-0.006	0.905	0.908	0.202	0.000	0.010	0.001	0.000	0.993	0.000	0.006	0.010	1.000	0.119	0.240	0.089	0.001	0.010
latitude	-0.003	0.002	0.000	0.002	0.006	0.639	0.003	1.000	-0.615	0.006	-0.002	0.002	-0.003	-0.004	-0.002	0.001	0.002	-0.000	0.000	0.002	-0.008	0.002	0.002	0.001	0.003	0.008	0.009	0.007	0.000	0.979	0.020	0.799	0.000	0.008	0.001	0.015	0.011	0.008
longitude	0.001	-0.003	0.003	0.015	-0.011	-0.946	0.004	-0.615	1.000	-0.011	0.021	0.015	0.001	0.000	0.021	0.004	-0.005	0.003	0.003	-0.003	-0.011	0.015	0.015	0.004	0.010	0.010	0.012	0.010	0.000	0.806	0.023	0.644	0.000	0.013	0.000	0.018	0.011	0.010
order_customer_id	0.004	0.003	0.013	0.133	1.000	-0.000	0.061	0.006	-0.011	1.000	0.133	0.133	0.003	0.002	0.133	0.039	-0.000	0.014	0.013	0.003	-0.006	0.133	0.133	0.039	0.005	0.009	0.006	0.004	0.512	0.015	0.031	0.050	0.336	0.179	0.099	0.134	0.008	0.009
order_id	-0.002	0.017	0.041	0.135	0.133	-0.002	0.063	-0.002	0.021	0.133	1.000	0.131	0.019	0.001	1.000	0.082	0.001	0.044	0.041	0.017	0.014	0.131	0.135	0.082	0.015	0.010	0.009	0.006	0.337	0.012	0.006	0.026	0.242	0.753	0.098	0.551	0.012	0.010
order_item_cardprod_id	-0.002	0.060	0.160	0.998	0.133	0.002	0.905	0.002	0.015	0.133	0.131	1.000	0.072	0.001	0.131	0.192	-0.002	0.176	0.160	0.060	-0.007	1.000	0.998	0.192	0.000	0.000	0.000	0.000	0.984	0.000	0.000	0.008	0.784	0.129	0.242	0.105	0.000	0.000
order_item_discount	0.001	0.196	0.420	0.073	0.003	-0.001	0.102	-0.003	0.001	0.003	0.019	0.072	1.000	0.795	0.019	0.356	-0.002	0.534	0.420	0.196	0.000	0.072	0.073	0.356	0.000	0.000	0.000	0.000	0.302	0.001	0.002	0.005	0.162	0.024	0.082	0.018	0.000	0.000
order_item_discount_rate	0.001	-0.054	-0.133	0.000	0.002	-0.001	0.000	-0.004	0.000	0.002	0.001	0.001	0.795	1.000	0.001	0.000	-0.002	0.000	-0.133	-0.054	0.000	0.001	0.000	0.000	0.000	0.000	0.004	0.006	0.000	0.003	0.000	0.000	0.000	0.000	0.000	0.000	0.002	0.000
order_item_id	-0.002	0.017	0.041	0.135	0.133	-0.002	0.063	-0.002	0.021	0.133	1.000	0.131	0.019	0.001	1.000	0.082	0.001	0.044	0.041	0.017	0.014	0.131	0.135	0.082	0.015	0.010	0.008	0.008	0.232	0.011	0.007	0.025	0.166	0.714	0.076	0.532	0.011	0.010
order_item_product_price	-0.000	0.287	0.639	0.195	0.039	0.002	0.202	0.001	0.004	0.039	0.082	0.192	0.356	0.000	0.082	1.000	0.000	0.667	0.639	0.287	-0.001	0.192	0.195	1.000	0.005	0.008	0.000	0.004	0.807	0.000	0.002	0.000	0.394	0.059	0.229	0.060	0.003	0.008
order_item_profit_ratio	-0.003	0.808	-0.000	-0.002	-0.000	0.005	-0.003	0.002	-0.005	-0.000	0.001	-0.002	-0.002	-0.002	0.001	0.000	1.000	-0.001	-0.000	0.808	-0.006	-0.002	-0.002	0.000	0.000	0.000	0.000	0.000	0.002	0.000	0.000	0.001	0.000	0.005	0.000	0.000	0.000	0.000
sales	-0.000	0.436	0.986	0.178	0.014	-0.001	0.241	-0.000	0.003	0.014	0.044	0.176	0.534	0.000	0.044	0.667	-0.001	1.000	0.986	0.436	-0.003	0.176	0.178	0.667	0.005	0.006	0.000	0.002	0.685	0.000	0.004	0.000	0.343	0.042	0.235	0.042	0.004	0.006
order_item_total	-0.000	0.441	1.000	0.162	0.013	-0.001	0.224	0.000	0.003	0.013	0.041	0.160	0.420	-0.133	0.041	0.639	-0.000	0.986	1.000	0.441	-0.003	0.160	0.162	0.639	0.005	0.004	0.005	0.000	0.480	0.000	0.006	0.000	0.241	0.036	0.212	0.026	0.006	0.004
order_profit_per_order	-0.003	1.000	0.441	0.061	0.003	0.002	0.085	0.002	-0.003	0.003	0.017	0.060	0.196	-0.054	0.017	0.287	0.808	0.436	0.441	1.000	-0.007	0.060	0.061	0.287	0.003	0.002	0.000	0.000	0.232	0.000	0.000	0.011	0.127	0.021	0.034	0.014	0.000	0.002
order_zipcode	-0.002	-0.007	-0.003	-0.007	-0.006	0.011	-0.006	-0.008	-0.011	-0.006	0.014	-0.007	0.000	0.000	0.014	-0.001	-0.006	-0.003	-0.003	-0.007	1.000	-0.007	-0.007	-0.001	0.032	0.039	0.025	0.031	0.000	0.034	0.024	0.072	0.007	1.000	0.000	0.922	0.031	0.039
product_card_id	-0.002	0.060	0.160	0.998	0.133	0.002	0.905	0.002	0.015	0.133	0.131	1.000	0.072	0.001	0.131	0.192	-0.002	0.176	0.160	0.060	-0.007	1.000	0.998	0.192	0.000	0.000	0.000	0.000	0.984	0.000	0.000	0.008	0.784	0.129	0.242	0.105	0.000	0.000
product_category_id	-0.002	0.061	0.162	1.000	0.133	0.002	0.908	0.002	0.015	0.133	0.135	0.998	0.073	0.000	0.135	0.195	-0.002	0.178	0.162	0.061	-0.007	0.998	1.000	0.195	0.001	0.009	0.000	0.000	0.973	0.000	0.008	0.008	0.683	0.158	0.232	0.118	0.001	0.009
product_price	-0.000	0.287	0.639	0.195	0.039	0.002	0.202	0.001	0.004	0.039	0.082	0.192	0.356	0.000	0.082	1.000	0.000	0.667	0.639	0.287	-0.001	0.192	0.195	1.000	0.005	0.008	0.000	0.004	0.807	0.000	0.002	0.000	0.394	0.059	0.229	0.060	0.003	0.008
type	0.010	0.003	0.005	0.001	0.005	0.010	0.000	0.003	0.010	0.005	0.015	0.000	0.000	0.000	0.015	0.005	0.000	0.005	0.005	0.003	0.032	0.000	0.001	0.005	1.000	0.006	0.198	0.078	0.000	0.006	0.005	0.023	0.000	0.011	0.000	0.019	1.000	0.006
days_for_shipment_scheduled	0.681	0.002	0.004	0.009	0.009	0.013	0.010	0.008	0.010	0.009	0.010	0.000	0.000	0.000	0.010	0.008	0.000	0.006	0.004	0.002	0.039	0.000	0.009	0.008	0.006	1.000	0.321	0.457	0.018	0.009	0.008	0.027	0.010	0.007	0.002	0.023	0.009	1.000
delivery_status	0.561	0.000	0.005	0.000	0.006	0.012	0.001	0.009	0.012	0.006	0.009	0.000	0.000	0.004	0.008	0.000	0.000	0.000	0.005	0.000	0.025	0.000	0.000	0.000	0.198	0.321	1.000	1.000	0.000	0.003	0.005	0.024	0.000	0.006	0.000	0.018	0.577	0.321
late_delivery_risk	0.631	0.000	0.000	0.000	0.004	0.012	0.000	0.007	0.010	0.004	0.006	0.000	0.000	0.006	0.008	0.004	0.000	0.002	0.000	0.000	0.031	0.000	0.000	0.004	0.078	0.457	1.000	1.000	0.000	0.000	0.000	0.018	0.000	0.005	0.000	0.017	0.234	0.457
category_name	0.006	0.232	0.480	0.973	0.512	0.002	0.993	0.000	0.000	0.512	0.337	0.984	0.302	0.000	0.232	0.807	0.002	0.685	0.480	0.232	0.000	0.984	0.973	0.807	0.000	0.018	0.000	0.000	1.000	0.000	0.015	0.008	0.994	0.176	0.394	0.084	0.002	0.018
customer_country	0.011	0.000	0.000	0.000	0.015	0.902	0.000	0.979	0.806	0.015	0.012	0.000	0.001	0.003	0.011	0.000	0.000	0.000	0.000	0.000	0.034	0.000	0.000	0.000	0.006	0.009	0.003	0.000	0.000	1.000	0.015	1.000	0.000	0.015	0.000	0.020	0.009	0.009
customer_segment	0.009	0.000	0.006	0.008	0.031	0.028	0.006	0.020	0.023	0.031	0.006	0.000	0.002	0.000	0.007	0.002	0.000	0.004	0.006	0.000	0.024	0.000	0.008	0.002	0.005	0.008	0.005	0.000	0.015	0.015	1.000	0.061	0.006	0.002	0.004	0.017	0.011	0.008
customer_state	0.027	0.011	0.000	0.008	0.050	0.974	0.010	0.799	0.644	0.050	0.026	0.008	0.005	0.000	0.025	0.000	0.001	0.000	0.000	0.011	0.072	0.008	0.008	0.000	0.023	0.027	0.024	0.018	0.008	1.000	0.061	1.000	0.009	0.030	0.000	0.026	0.022	0.027
department_name	0.006	0.127	0.241	0.683	0.336	0.002	1.000	0.000	0.000	0.336	0.242	0.784	0.162	0.000	0.166	0.394	0.000	0.343	0.241	0.127	0.007	0.784	0.683	0.394	0.000	0.010	0.000	0.000	0.994	0.000	0.006	0.009	1.000	0.120	0.241	0.085	0.000	0.010
market	0.008	0.021	0.036	0.158	0.179	0.013	0.119	0.008	0.013	0.179	0.753	0.129	0.024	0.000	0.714	0.059	0.005	0.042	0.036	0.021	1.000	0.129	0.158	0.059	0.011	0.007	0.006	0.005	0.176	0.015	0.002	0.030	0.120	1.000	0.027	1.000	0.011	0.007
order_item_quantity	0.000	0.034	0.212	0.232	0.099	0.000	0.240	0.001	0.000	0.099	0.098	0.242	0.082	0.000	0.076	0.229	0.000	0.235	0.212	0.034	0.000	0.242	0.232	0.229	0.000	0.002	0.000	0.000	0.394	0.000	0.004	0.000	0.241	0.027	1.000	0.031	0.000	0.002
order_region	0.022	0.014	0.026	0.118	0.134	0.018	0.089	0.015	0.018	0.134	0.551	0.105	0.018	0.000	0.532	0.060	0.000	0.042	0.026	0.014	0.922	0.105	0.118	0.060	0.019	0.023	0.018	0.017	0.084	0.020	0.017	0.026	0.085	1.000	0.031	1.000	0.017	0.023
order_status	0.008	0.000	0.006	0.001	0.008	0.010	0.001	0.011	0.011	0.008	0.012	0.000	0.000	0.002	0.011	0.003	0.000	0.004	0.006	0.000	0.031	0.000	0.001	0.003	1.000	0.009	0.577	0.234	0.002	0.009	0.011	0.022	0.000	0.011	0.000	0.017	1.000	0.009
shipping_mode	0.681	0.002	0.004	0.009	0.009	0.013	0.010	0.008	0.010	0.009	0.010	0.000	0.000	0.000	0.010	0.008	0.000	0.006	0.004	0.002	0.039	0.000	0.009	0.008	0.006	1.000	0.321	0.457	0.018	0.009	0.008	0.027	0.010	0.007	0.002	0.023	0.009	1.000

A simple visualization of nullity by column.

Nullity matrix is a data-dense display which lets you quickly visually pick out patterns in data completion.

The correlation heatmap measures nullity correlation: how strongly the presence or absence of one variable affects the presence of another.

First rows
Last rows

	type	days_for_shipping_real	days_for_shipment_scheduled	benefit_per_order	sales_per_customer	delivery_status	late_delivery_risk	category_id	category_name	customer_city	customer_country	customer_email	customer_fname	customer_id	customer_lname	customer_password	customer_segment	customer_state	customer_street	customer_zipcode	department_id	department_name	latitude	longitude	market	order_city	order_country	order_customer_id	order_date_dateorders	order_id	order_item_cardprod_id	order_item_discount	order_item_discount_rate	order_item_id	order_item_product_price	order_item_profit_ratio	order_item_quantity	sales	order_item_total	order_profit_per_order	order_region	order_state	order_status	order_zipcode	product_card_id	product_category_id	product_description	product_image	product_name	product_price	shipping_date_dateorders	shipping_mode
0	DEBIT	3	4	91.250000	314.640015	Advance shipping	0	73	Sporting Goods	Caguas	Puerto Rico	XXXXXXXXX	Cally	20755	Holloway	XXXXXXXXX	Consumer	PR	5365 Noble Nectar Island	725.0	2	Fitness	18.251453	-66.037056	Pacific Asia	Bekasi	Indonesia	20755	1/31/2018 22:56	77202	1360	13.110000	0.04	180517	327.75	0.29	1	327.75	314.640015	91.250000	Southeast Asia	Java Occidental	COMPLETE	NaN	1360	73	NaN	http://images.acmesports.sports/Smart+watch	Smart watch	327.75	2/3/2018 22:56	Standard Class
1	TRANSFER	5	4	-249.089996	311.359985	Late delivery	1	73	Sporting Goods	Caguas	Puerto Rico	XXXXXXXXX	Irene	19492	Luna	XXXXXXXXX	Consumer	PR	2679 Rustic Loop	725.0	2	Fitness	18.279451	-66.037064	Pacific Asia	Bikaner	India	19492	1/13/2018 12:27	75939	1360	16.389999	0.05	179254	327.75	-0.80	1	327.75	311.359985	-249.089996	South Asia	Rajastán	PENDING	NaN	1360	73	NaN	http://images.acmesports.sports/Smart+watch	Smart watch	327.75	1/18/2018 12:27	Standard Class
2	CASH	4	4	-247.779999	309.720001	Shipping on time	0	73	Sporting Goods	San Jose	EE. UU.	XXXXXXXXX	Gillian	19491	Maldonado	XXXXXXXXX	Consumer	CA	8510 Round Bear Gate	95125.0	2	Fitness	37.292233	-121.881279	Pacific Asia	Bikaner	India	19491	1/13/2018 12:06	75938	1360	18.030001	0.06	179253	327.75	-0.80	1	327.75	309.720001	-247.779999	South Asia	Rajastán	CLOSED	NaN	1360	73	NaN	http://images.acmesports.sports/Smart+watch	Smart watch	327.75	1/17/2018 12:06	Standard Class
3	DEBIT	3	4	22.860001	304.809998	Advance shipping	0	73	Sporting Goods	Los Angeles	EE. UU.	XXXXXXXXX	Tana	19490	Tate	XXXXXXXXX	Home Office	CA	3200 Amber Bend	90027.0	2	Fitness	34.125946	-118.291016	Pacific Asia	Townsville	Australia	19490	1/13/2018 11:45	75937	1360	22.940001	0.07	179252	327.75	0.08	1	327.75	304.809998	22.860001	Oceania	Queensland	COMPLETE	NaN	1360	73	NaN	http://images.acmesports.sports/Smart+watch	Smart watch	327.75	1/16/2018 11:45	Standard Class
4	PAYMENT	2	4	134.210007	298.250000	Advance shipping	0	73	Sporting Goods	Caguas	Puerto Rico	XXXXXXXXX	Orli	19489	Hendricks	XXXXXXXXX	Corporate	PR	8671 Iron Anchor Corners	725.0	2	Fitness	18.253769	-66.037048	Pacific Asia	Townsville	Australia	19489	1/13/2018 11:24	75936	1360	29.500000	0.09	179251	327.75	0.45	1	327.75	298.250000	134.210007	Oceania	Queensland	PENDING_PAYMENT	NaN	1360	73	NaN	http://images.acmesports.sports/Smart+watch	Smart watch	327.75	1/15/2018 11:24	Standard Class
5	TRANSFER	6	4	18.580000	294.980011	Shipping canceled	0	73	Sporting Goods	Tonawanda	EE. UU.	XXXXXXXXX	Kimberly	19488	Flowers	XXXXXXXXX	Consumer	NY	2122 Hazy Corner	14150.0	2	Fitness	43.013969	-78.879066	Pacific Asia	Toowoomba	Australia	19488	1/13/2018 11:03	75935	1360	32.779999	0.10	179250	327.75	0.06	1	327.75	294.980011	18.580000	Oceania	Queensland	CANCELED	NaN	1360	73	NaN	http://images.acmesports.sports/Smart+watch	Smart watch	327.75	1/19/2018 11:03	Standard Class
6	DEBIT	2	1	95.180000	288.420013	Late delivery	1	73	Sporting Goods	Caguas	Puerto Rico	XXXXXXXXX	Constance	19487	Terrell	XXXXXXXXX	Home Office	PR	1879 Green Pine Bank	725.0	2	Fitness	18.242538	-66.037056	Pacific Asia	Guangzhou	China	19487	1/13/2018 10:42	75934	1360	39.330002	0.12	179249	327.75	0.33	1	327.75	288.420013	95.180000	Eastern Asia	Guangdong	COMPLETE	NaN	1360	73	NaN	http://images.acmesports.sports/Smart+watch	Smart watch	327.75	1/15/2018 10:42	First Class
7	TRANSFER	2	1	68.430000	285.140015	Late delivery	1	73	Sporting Goods	Miami	EE. UU.	XXXXXXXXX	Erica	19486	Stevens	XXXXXXXXX	Corporate	FL	7595 Cotton Log Row	33162.0	2	Fitness	25.928869	-80.162872	Pacific Asia	Guangzhou	China	19486	1/13/2018 10:21	75933	1360	42.610001	0.13	179248	327.75	0.24	1	327.75	285.140015	68.430000	Eastern Asia	Guangdong	PROCESSING	NaN	1360	73	NaN	http://images.acmesports.sports/Smart+watch	Smart watch	327.75	1/15/2018 10:21	First Class
8	CASH	3	2	133.720001	278.589996	Late delivery	1	73	Sporting Goods	Caguas	Puerto Rico	XXXXXXXXX	Nichole	19485	Olsen	XXXXXXXXX	Corporate	PR	2051 Dusty Route	725.0	2	Fitness	18.233223	-66.037056	Pacific Asia	Guangzhou	China	19485	1/13/2018 10:00	75932	1360	49.160000	0.15	179247	327.75	0.48	1	327.75	278.589996	133.720001	Eastern Asia	Guangdong	CLOSED	NaN	1360	73	NaN	http://images.acmesports.sports/Smart+watch	Smart watch	327.75	1/16/2018 10:00	Second Class
9	CASH	2	1	132.149994	275.309998	Late delivery	1	73	Sporting Goods	San Ramon	EE. UU.	XXXXXXXXX	Oprah	19484	Delacruz	XXXXXXXXX	Corporate	CA	9139 Blue Blossom Court	94583.0	2	Fitness	37.773991	-121.966629	Pacific Asia	Guangzhou	China	19484	1/13/2018 9:39	75931	1360	52.439999	0.16	179246	327.75	0.48	1	327.75	275.309998	132.149994	Eastern Asia	Guangdong	CLOSED	NaN	1360	73	NaN	http://images.acmesports.sports/Smart+watch	Smart watch	327.75	1/15/2018 9:39	First Class

	type	days_for_shipping_real	days_for_shipment_scheduled	benefit_per_order	sales_per_customer	delivery_status	late_delivery_risk	category_id	category_name	customer_city	customer_country	customer_email	customer_fname	customer_id	customer_lname	customer_password	customer_segment	customer_state	customer_street	customer_zipcode	department_id	department_name	latitude	longitude	market	order_city	order_country	order_customer_id	order_date_dateorders	order_id	order_item_cardprod_id	order_item_discount	order_item_discount_rate	order_item_id	order_item_product_price	order_item_profit_ratio	order_item_quantity	sales	order_item_total	order_profit_per_order	order_region	order_state	order_status	order_zipcode	product_card_id	product_category_id	product_description	product_image	product_name	product_price	shipping_date_dateorders	shipping_mode
180509	PAYMENT	3	4	0.000000	335.980011	Advance shipping	0	45	Fishing	Caguas	Puerto Rico	XXXXXXXXX	Melissa	7	Wilcox	XXXXXXXXX	Corporate	PR	9453 High Concession	725.0	7	Fan Shop	18.359095	-66.079956	Pacific Asia	Guangshui	China	7	1/16/2016 6:49	26052	1004	64.0	0.16	65202	399.980011	0.00	1	399.980011	335.980011	0.000000	Eastern Asia	Hubei	PENDING_PAYMENT	NaN	1004	45	NaN	http://images.acmesports.sports/Field+%26+Stream+Sportsman+16+Gun+Fire+Safe	Field & Stream Sportsman 16 Gun Fire Safe	399.980011	1/19/2016 6:49	Standard Class
180510	PAYMENT	3	4	165.990005	331.980011	Advance shipping	0	45	Fishing	Caguas	Puerto Rico	XXXXXXXXX	Melissa	7	Wilcox	XXXXXXXXX	Corporate	PR	9453 High Concession	725.0	7	Fan Shop	18.359095	-66.079956	Pacific Asia	Guangshui	China	7	1/16/2016 6:49	26052	1004	68.0	0.17	65201	399.980011	0.50	1	399.980011	331.980011	165.990005	Eastern Asia	Hubei	PENDING_PAYMENT	NaN	1004	45	NaN	http://images.acmesports.sports/Field+%26+Stream+Sportsman+16+Gun+Fire+Safe	Field & Stream Sportsman 16 Gun Fire Safe	399.980011	1/19/2016 6:49	Standard Class
180511	DEBIT	2	2	157.429993	327.980011	Shipping on time	0	45	Fishing	Chula Vista	EE. UU.	XXXXXXXXX	Olivia	9314	Smith	XXXXXXXXX	Consumer	CA	3760 Stony Promenade	91911.0	7	Fan Shop	32.611141	-117.073662	Pacific Asia	Chengdu	China	9314	1/16/2016 6:28	26051	1004	72.0	0.18	65195	399.980011	0.48	1	399.980011	327.980011	157.429993	Eastern Asia	Sichuan	ON_HOLD	NaN	1004	45	NaN	http://images.acmesports.sports/Field+%26+Stream+Sportsman+16+Gun+Fire+Safe	Field & Stream Sportsman 16 Gun Fire Safe	399.980011	1/18/2016 6:28	Second Class
180512	DEBIT	6	4	86.400002	319.980011	Late delivery	1	45	Fishing	Caguas	Puerto Rico	XXXXXXXXX	Mary	7396	Madden	XXXXXXXXX	Home Office	PR	9918 Lazy Cape	725.0	7	Fan Shop	18.245256	-66.370621	Pacific Asia	Chengdu	China	7396	1/16/2016 6:07	26050	1004	80.0	0.20	65194	399.980011	0.27	1	399.980011	319.980011	86.400002	Eastern Asia	Sichuan	COMPLETE	NaN	1004	45	NaN	http://images.acmesports.sports/Field+%26+Stream+Sportsman+16+Gun+Fire+Safe	Field & Stream Sportsman 16 Gun Fire Safe	399.980011	1/22/2016 6:07	Standard Class
180513	PAYMENT	3	4	119.989998	299.989990	Advance shipping	0	45	Fishing	Lancaster	EE. UU.	XXXXXXXXX	Mary	3080	Smith	XXXXXXXXX	Home Office	OH	8600 Red Goose Abbey	43130.0	7	Fan Shop	39.715977	-82.599297	Pacific Asia	Shanghái	China	3080	1/16/2016 5:04	26047	1004	100.0	0.25	65185	399.980011	0.40	1	399.980011	299.989990	119.989998	Eastern Asia	Shanghái	PENDING_PAYMENT	NaN	1004	45	NaN	http://images.acmesports.sports/Field+%26+Stream+Sportsman+16+Gun+Fire+Safe	Field & Stream Sportsman 16 Gun Fire Safe	399.980011	1/19/2016 5:04	Standard Class
180514	CASH	4	4	40.000000	399.980011	Shipping on time	0	45	Fishing	Brooklyn	EE. UU.	XXXXXXXXX	Maria	1005	Peterson	XXXXXXXXX	Home Office	NY	1322 Broad Glade	11207.0	7	Fan Shop	40.640930	-73.942711	Pacific Asia	Shanghái	China	1005	1/16/2016 3:40	26043	1004	0.0	0.00	65177	399.980011	0.10	1	399.980011	399.980011	40.000000	Eastern Asia	Shanghái	CLOSED	NaN	1004	45	NaN	http://images.acmesports.sports/Field+%26+Stream+Sportsman+16+Gun+Fire+Safe	Field & Stream Sportsman 16 Gun Fire Safe	399.980011	1/20/2016 3:40	Standard Class
180515	DEBIT	3	2	-613.770019	395.980011	Late delivery	1	45	Fishing	Bakersfield	EE. UU.	XXXXXXXXX	Ronald	9141	Clark	XXXXXXXXX	Corporate	CA	7330 Broad Apple Moor	93304.0	7	Fan Shop	35.362545	-119.018700	Pacific Asia	Hirakata	Japón	9141	1/16/2016 1:34	26037	1004	4.0	0.01	65161	399.980011	-1.55	1	399.980011	395.980011	-613.770019	Eastern Asia	Osaka	COMPLETE	NaN	1004	45	NaN	http://images.acmesports.sports/Field+%26+Stream+Sportsman+16+Gun+Fire+Safe	Field & Stream Sportsman 16 Gun Fire Safe	399.980011	1/19/2016 1:34	Second Class
180516	TRANSFER	5	4	141.110001	391.980011	Late delivery	1	45	Fishing	Bristol	EE. UU.	XXXXXXXXX	John	291	Smith	XXXXXXXXX	Corporate	CT	97 Burning Landing	6010.0	7	Fan Shop	41.629959	-72.967155	Pacific Asia	Adelaide	Australia	291	1/15/2016 21:00	26024	1004	8.0	0.02	65129	399.980011	0.36	1	399.980011	391.980011	141.110001	Oceania	Australia del Sur	PENDING	NaN	1004	45	NaN	http://images.acmesports.sports/Field+%26+Stream+Sportsman+16+Gun+Fire+Safe	Field & Stream Sportsman 16 Gun Fire Safe	399.980011	1/20/2016 21:00	Standard Class
180517	PAYMENT	3	4	186.229996	387.980011	Advance shipping	0	45	Fishing	Caguas	Puerto Rico	XXXXXXXXX	Mary	2813	Smith	XXXXXXXXX	Consumer	PR	2585 Silent Autumn Landing	725.0	7	Fan Shop	18.213350	-66.370575	Pacific Asia	Adelaide	Australia	2813	1/15/2016 20:18	26022	1004	12.0	0.03	65126	399.980011	0.48	1	399.980011	387.980011	186.229996	Oceania	Australia del Sur	PENDING_PAYMENT	NaN	1004	45	NaN	http://images.acmesports.sports/Field+%26+Stream+Sportsman+16+Gun+Fire+Safe	Field & Stream Sportsman 16 Gun Fire Safe	399.980011	1/18/2016 20:18	Standard Class
180518	PAYMENT	4	4	168.949997	383.980011	Shipping on time	0	45	Fishing	Caguas	Puerto Rico	XXXXXXXXX	Andrea	7547	Ortega	XXXXXXXXX	Consumer	PR	697 Little Meadow	725.0	7	Fan Shop	18.290380	-66.370613	Pacific Asia	Nagercoil	India	7547	1/15/2016 18:54	26018	1004	16.0	0.04	65113	399.980011	0.44	1	399.980011	383.980011	168.949997	South Asia	Tamil Nadu	PENDING_PAYMENT	NaN	1004	45	NaN	http://images.acmesports.sports/Field+%26+Stream+Sportsman+16+Gun+Fire+Safe	Field & Stream Sportsman 16 Gun Fire Safe	399.980011	1/19/2016 18:54	Standard Class

Overview

Variables

Common Values

Length

Common Values (Plot)

Most occurring characters

Most occurring categories

Most frequent character per category

Uppercase Letter

Most occurring scripts

Most frequent character per script

Latin

Most occurring blocks

Most frequent character per block

ASCII

Common Values

Length

Common Values (Plot)

Most occurring characters

Most occurring categories

Most frequent character per category

Decimal Number

Most occurring scripts

Most frequent character per script

Common

Most occurring blocks

Most frequent character per block

ASCII

Common Values

Length

Common Values (Plot)

Most occurring characters

Most occurring categories

Most frequent character per category

Lowercase Letter

Uppercase Letter

Space Separator

Most occurring scripts

Most frequent character per script

Latin

Common

Most occurring blocks

Most frequent character per block

ASCII

Common Values

Length

Common Values (Plot)

Most occurring characters

Most occurring categories

Most frequent character per category

Decimal Number

Most occurring scripts

Most frequent character per script

Common

Most occurring blocks

Most frequent character per block

ASCII

Common Values

Length

Most occurring characters

Most occurring categories

Most frequent character per category

Lowercase Letter

Uppercase Letter

Other Punctuation

Space Separator

Dash Punctuation

Most occurring scripts

Most frequent character per script

Latin

Common

Most occurring blocks

Most frequent character per block

ASCII

Common Values

Length

Most occurring characters

Most occurring categories

Most frequent character per category

Lowercase Letter